{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts\n",
    "import sys\n",
    "import time\n",
    "import json\n",
    "import pandas as pd\n",
    "from dateutil.parser import parse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "token = \"17e7755e254f02cc312b8b7e22ded9a308924147f8546fdfbe653ba1\"\n",
    "ts.set_token(token)\n",
    "cons = ts.get_apis()\n",
    "pro = ts.pro_api()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>price</th>\n",
       "      <th>last_close</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>vol</th>\n",
       "      <th>cur_vol</th>\n",
       "      <th>amount</th>\n",
       "      <th>s_vol</th>\n",
       "      <th>...</th>\n",
       "      <th>bid_vol3</th>\n",
       "      <th>ask_vol3</th>\n",
       "      <th>bid4</th>\n",
       "      <th>ask4</th>\n",
       "      <th>bid_vol4</th>\n",
       "      <th>ask_vol4</th>\n",
       "      <th>bid5</th>\n",
       "      <th>ask5</th>\n",
       "      <th>bid_vol5</th>\n",
       "      <th>ask_vol5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123001</td>\n",
       "      <td>1360.04</td>\n",
       "      <td>1369.1</td>\n",
       "      <td>1370.7</td>\n",
       "      <td>1409.0</td>\n",
       "      <td>1356.0</td>\n",
       "      <td>58737</td>\n",
       "      <td>19</td>\n",
       "      <td>81333888.0</td>\n",
       "      <td>30326</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>5</td>\n",
       "      <td>1358.1</td>\n",
       "      <td>1364.99</td>\n",
       "      <td>1</td>\n",
       "      <td>100</td>\n",
       "      <td>1358.00</td>\n",
       "      <td>1365.00</td>\n",
       "      <td>10</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>127003</td>\n",
       "      <td>1049.80</td>\n",
       "      <td>1044.7</td>\n",
       "      <td>1037.1</td>\n",
       "      <td>1050.5</td>\n",
       "      <td>1036.0</td>\n",
       "      <td>30960</td>\n",
       "      <td>1</td>\n",
       "      <td>32348976.0</td>\n",
       "      <td>18704</td>\n",
       "      <td>...</td>\n",
       "      <td>77</td>\n",
       "      <td>87</td>\n",
       "      <td>1049.0</td>\n",
       "      <td>1049.90</td>\n",
       "      <td>500</td>\n",
       "      <td>151</td>\n",
       "      <td>1048.15</td>\n",
       "      <td>1049.98</td>\n",
       "      <td>8</td>\n",
       "      <td>196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>110030</td>\n",
       "      <td>1047.50</td>\n",
       "      <td>1047.2</td>\n",
       "      <td>1047.0</td>\n",
       "      <td>1048.6</td>\n",
       "      <td>1044.2</td>\n",
       "      <td>5945</td>\n",
       "      <td>11</td>\n",
       "      <td>6218688.0</td>\n",
       "      <td>4140</td>\n",
       "      <td>...</td>\n",
       "      <td>70</td>\n",
       "      <td>3</td>\n",
       "      <td>1045.9</td>\n",
       "      <td>1048.70</td>\n",
       "      <td>248</td>\n",
       "      <td>80</td>\n",
       "      <td>1045.80</td>\n",
       "      <td>1048.80</td>\n",
       "      <td>215</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>113523</td>\n",
       "      <td>1120.00</td>\n",
       "      <td>1114.1</td>\n",
       "      <td>1116.1</td>\n",
       "      <td>1139.0</td>\n",
       "      <td>1116.1</td>\n",
       "      <td>1182</td>\n",
       "      <td>1</td>\n",
       "      <td>1330749.0</td>\n",
       "      <td>571</td>\n",
       "      <td>...</td>\n",
       "      <td>850</td>\n",
       "      <td>1</td>\n",
       "      <td>1118.1</td>\n",
       "      <td>1125.80</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>1118.00</td>\n",
       "      <td>1126.00</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     code    price  last_close    open    high     low    vol  cur_vol  \\\n",
       "0  123001  1360.04      1369.1  1370.7  1409.0  1356.0  58737       19   \n",
       "0  127003  1049.80      1044.7  1037.1  1050.5  1036.0  30960        1   \n",
       "0  110030  1047.50      1047.2  1047.0  1048.6  1044.2   5945       11   \n",
       "0  113523  1120.00      1114.1  1116.1  1139.0  1116.1   1182        1   \n",
       "\n",
       "       amount  s_vol    ...     bid_vol3  ask_vol3    bid4     ask4  bid_vol4  \\\n",
       "0  81333888.0  30326    ...           50         5  1358.1  1364.99         1   \n",
       "0  32348976.0  18704    ...           77        87  1049.0  1049.90       500   \n",
       "0   6218688.0   4140    ...           70         3  1045.9  1048.70       248   \n",
       "0   1330749.0    571    ...          850         1  1118.1  1125.80        10   \n",
       "\n",
       "   ask_vol4     bid5     ask5  bid_vol5  ask_vol5  \n",
       "0       100  1358.00  1365.00        10        60  \n",
       "0       151  1048.15  1049.98         8       196  \n",
       "0        80  1045.80  1048.80       215       150  \n",
       "0         2  1118.00  1126.00        10         3  \n",
       "\n",
       "[4 rows x 31 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_codes = [\"123001\",\"127003\",\"110030\",\"113523\"]\n",
    "bond_realTime_price = ts.quotes(bond_codes, conn=cons)\n",
    "bond_realTime_price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([0, 0, 0, 0], dtype='int64')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_realTime_price.set_index(\"code\")\n",
    "bond_realTime_price.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['code', 'price', 'last_close', 'open', 'high', 'low', 'vol', 'cur_vol',\n",
       "       'amount', 's_vol', 'b_vol', 'bid1', 'ask1', 'bid_vol1', 'ask_vol1',\n",
       "       'bid2', 'ask2', 'bid_vol2', 'ask_vol2', 'bid3', 'ask3', 'bid_vol3',\n",
       "       'ask_vol3', 'bid4', 'ask4', 'bid_vol4', 'ask_vol4', 'bid5', 'ask5',\n",
       "       'bid_vol5', 'ask_vol5'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bond_realTime_price.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bond_code</th>\n",
       "      <th>bond_name</th>\n",
       "      <th>bond_price</th>\n",
       "      <th>bond_x1</th>\n",
       "      <th>stock_price</th>\n",
       "      <th>stock_x1</th>\n",
       "      <th>pb</th>\n",
       "      <th>convert_price</th>\n",
       "      <th>convert_value</th>\n",
       "      <th>premium</th>\n",
       "      <th>...</th>\n",
       "      <th>shuishou_price</th>\n",
       "      <th>qiangshu_price</th>\n",
       "      <th>bond_x2</th>\n",
       "      <th>bond_x3</th>\n",
       "      <th>expire</th>\n",
       "      <th>year</th>\n",
       "      <th>return</th>\n",
       "      <th>shuishou_ret</th>\n",
       "      <th>amount</th>\n",
       "      <th>operation</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stock_name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>广电网络</th>\n",
       "      <td>110044</td>\n",
       "      <td>广电转债</td>\n",
       "      <td>98.990</td>\n",
       "      <td>0.55%</td>\n",
       "      <td>7.06</td>\n",
       "      <td>3.67%</td>\n",
       "      <td>1.34</td>\n",
       "      <td>6.91</td>\n",
       "      <td>102.03</td>\n",
       "      <td>-2.98%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.84</td>\n",
       "      <td>8.98</td>\n",
       "      <td>18.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/6/27</td>\n",
       "      <td>5.521</td>\n",
       "      <td>2.53%</td>\n",
       "      <td>2.07%</td>\n",
       "      <td>购买</td>\n",
       "      <td>8124.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>德尔股份</th>\n",
       "      <td>123011</td>\n",
       "      <td>德尔转债</td>\n",
       "      <td>97.880</td>\n",
       "      <td>-0.02%</td>\n",
       "      <td>35.14</td>\n",
       "      <td>-0.03%</td>\n",
       "      <td>1.90</td>\n",
       "      <td>34.96</td>\n",
       "      <td>100.74</td>\n",
       "      <td>-2.84%</td>\n",
       "      <td>...</td>\n",
       "      <td>24.47</td>\n",
       "      <td>45.45</td>\n",
       "      <td>15.30%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/7/18</td>\n",
       "      <td>5.578</td>\n",
       "      <td>3.42%</td>\n",
       "      <td>2.83%</td>\n",
       "      <td>购买</td>\n",
       "      <td>552.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>盛路通信</th>\n",
       "      <td>128041</td>\n",
       "      <td>盛路转债</td>\n",
       "      <td>99.670</td>\n",
       "      <td>-0.16%</td>\n",
       "      <td>7.06</td>\n",
       "      <td>-0.14%</td>\n",
       "      <td>1.90</td>\n",
       "      <td>6.88</td>\n",
       "      <td>102.47</td>\n",
       "      <td>-2.73%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.82</td>\n",
       "      <td>8.94</td>\n",
       "      <td>18.60%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/7/16</td>\n",
       "      <td>5.573</td>\n",
       "      <td>2.74%</td>\n",
       "      <td>2.22%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2756.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鼎信通讯</th>\n",
       "      <td>113506</td>\n",
       "      <td>鼎信转债</td>\n",
       "      <td>105.980</td>\n",
       "      <td>0.26%</td>\n",
       "      <td>23.41</td>\n",
       "      <td>-1.72%</td>\n",
       "      <td>4.28</td>\n",
       "      <td>21.65</td>\n",
       "      <td>108.36</td>\n",
       "      <td>-2.20%</td>\n",
       "      <td>...</td>\n",
       "      <td>15.15</td>\n",
       "      <td>28.14</td>\n",
       "      <td>5.30%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/4/16</td>\n",
       "      <td>5.323</td>\n",
       "      <td>0.82%</td>\n",
       "      <td>0.45%</td>\n",
       "      <td>购买</td>\n",
       "      <td>10791.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>梦百合</th>\n",
       "      <td>113520</td>\n",
       "      <td>百合转债</td>\n",
       "      <td>101.690</td>\n",
       "      <td>1.99%</td>\n",
       "      <td>19.68</td>\n",
       "      <td>3.47%</td>\n",
       "      <td>2.88</td>\n",
       "      <td>19.03</td>\n",
       "      <td>103.47</td>\n",
       "      <td>-1.72%</td>\n",
       "      <td>...</td>\n",
       "      <td>13.32</td>\n",
       "      <td>24.74</td>\n",
       "      <td>10.80%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/8</td>\n",
       "      <td>5.888</td>\n",
       "      <td>2.26%</td>\n",
       "      <td>1.77%</td>\n",
       "      <td>购买</td>\n",
       "      <td>5335.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华源控股</th>\n",
       "      <td>128049</td>\n",
       "      <td>华源转债</td>\n",
       "      <td>92.120</td>\n",
       "      <td>-1.17%</td>\n",
       "      <td>7.07</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>1.62</td>\n",
       "      <td>7.58</td>\n",
       "      <td>93.40</td>\n",
       "      <td>-1.37%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.31</td>\n",
       "      <td>9.85</td>\n",
       "      <td>18.50%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/27</td>\n",
       "      <td>5.940</td>\n",
       "      <td>4.00%</td>\n",
       "      <td>3.49%</td>\n",
       "      <td>购买</td>\n",
       "      <td>4121.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>万顺股份</th>\n",
       "      <td>123012</td>\n",
       "      <td>万顺转债</td>\n",
       "      <td>95.100</td>\n",
       "      <td>-1.59%</td>\n",
       "      <td>6.22</td>\n",
       "      <td>-2.66%</td>\n",
       "      <td>1.02</td>\n",
       "      <td>6.47</td>\n",
       "      <td>95.83</td>\n",
       "      <td>-0.76%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.53</td>\n",
       "      <td>8.41</td>\n",
       "      <td>34.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/7/20</td>\n",
       "      <td>5.584</td>\n",
       "      <td>2.92%</td>\n",
       "      <td>2.52%</td>\n",
       "      <td>购买</td>\n",
       "      <td>683.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小康股份</th>\n",
       "      <td>113016</td>\n",
       "      <td>小康转债</td>\n",
       "      <td>97.920</td>\n",
       "      <td>-0.10%</td>\n",
       "      <td>16.87</td>\n",
       "      <td>-0.24%</td>\n",
       "      <td>3.18</td>\n",
       "      <td>17.200*</td>\n",
       "      <td>98.08</td>\n",
       "      <td>-0.16%</td>\n",
       "      <td>...</td>\n",
       "      <td>12.04</td>\n",
       "      <td>22.36</td>\n",
       "      <td>5.50%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/11/6</td>\n",
       "      <td>4.879</td>\n",
       "      <td>2.62%</td>\n",
       "      <td>2.19%</td>\n",
       "      <td>购买</td>\n",
       "      <td>154.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>旭升股份</th>\n",
       "      <td>113522</td>\n",
       "      <td>旭升转债</td>\n",
       "      <td>102.150</td>\n",
       "      <td>0.23%</td>\n",
       "      <td>30.18</td>\n",
       "      <td>0.90%</td>\n",
       "      <td>9.00</td>\n",
       "      <td>29.86</td>\n",
       "      <td>101.14</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>20.9</td>\n",
       "      <td>38.82</td>\n",
       "      <td>3.50%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/22</td>\n",
       "      <td>5.926</td>\n",
       "      <td>2.85%</td>\n",
       "      <td>2.24%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1278.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>三力士</th>\n",
       "      <td>128039</td>\n",
       "      <td>三力转债</td>\n",
       "      <td>96.066</td>\n",
       "      <td>-0.42%</td>\n",
       "      <td>5.52</td>\n",
       "      <td>-1.60%</td>\n",
       "      <td>1.90</td>\n",
       "      <td>5.840*</td>\n",
       "      <td>94.52</td>\n",
       "      <td>1.64%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.09</td>\n",
       "      <td>7.59</td>\n",
       "      <td>17.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/6/7</td>\n",
       "      <td>5.466</td>\n",
       "      <td>2.66%</td>\n",
       "      <td>2.28%</td>\n",
       "      <td>购买</td>\n",
       "      <td>297.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蓝盾股份</th>\n",
       "      <td>123015</td>\n",
       "      <td>蓝盾转债</td>\n",
       "      <td>92.280</td>\n",
       "      <td>-0.02%</td>\n",
       "      <td>5.25</td>\n",
       "      <td>0.77%</td>\n",
       "      <td>1.44</td>\n",
       "      <td>5.820*</td>\n",
       "      <td>90.03</td>\n",
       "      <td>2.49%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.07</td>\n",
       "      <td>7.57</td>\n",
       "      <td>8.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/8/13</td>\n",
       "      <td>5.649</td>\n",
       "      <td>3.78%</td>\n",
       "      <td>3.32%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1407.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吴江银行</th>\n",
       "      <td>113516</td>\n",
       "      <td>吴银转债</td>\n",
       "      <td>104.640</td>\n",
       "      <td>-0.91%</td>\n",
       "      <td>6.45</td>\n",
       "      <td>-2.42%</td>\n",
       "      <td>1.01</td>\n",
       "      <td>6.34</td>\n",
       "      <td>101.74</td>\n",
       "      <td>2.86%</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>8.24</td>\n",
       "      <td>26.80%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/8/1</td>\n",
       "      <td>5.616</td>\n",
       "      <td>1.83%</td>\n",
       "      <td>1.32%</td>\n",
       "      <td>购买</td>\n",
       "      <td>6274.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国祯环保</th>\n",
       "      <td>123002</td>\n",
       "      <td>国祯转债</td>\n",
       "      <td>107.500</td>\n",
       "      <td>-0.01%</td>\n",
       "      <td>9.04</td>\n",
       "      <td>-0.11%</td>\n",
       "      <td>2.29</td>\n",
       "      <td>8.720*</td>\n",
       "      <td>103.90</td>\n",
       "      <td>3.47%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.1</td>\n",
       "      <td>11.34</td>\n",
       "      <td>12.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/11/24</td>\n",
       "      <td>4.929</td>\n",
       "      <td>0.53%</td>\n",
       "      <td>0.14%</td>\n",
       "      <td>购买</td>\n",
       "      <td>8.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>安井食品</th>\n",
       "      <td>113513</td>\n",
       "      <td>安井转债</td>\n",
       "      <td>106.600</td>\n",
       "      <td>-0.27%</td>\n",
       "      <td>36.50</td>\n",
       "      <td>-0.73%</td>\n",
       "      <td>3.99</td>\n",
       "      <td>35.46</td>\n",
       "      <td>102.88</td>\n",
       "      <td>3.62%</td>\n",
       "      <td>...</td>\n",
       "      <td>24.82</td>\n",
       "      <td>46.1</td>\n",
       "      <td>6.30%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/7/12</td>\n",
       "      <td>5.562</td>\n",
       "      <td>1.09%</td>\n",
       "      <td>0.66%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1367.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>横河模具</th>\n",
       "      <td>123013</td>\n",
       "      <td>横河转债</td>\n",
       "      <td>92.295</td>\n",
       "      <td>-0.22%</td>\n",
       "      <td>8.25</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>4.22</td>\n",
       "      <td>9.26</td>\n",
       "      <td>88.98</td>\n",
       "      <td>3.72%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.48</td>\n",
       "      <td>12.04</td>\n",
       "      <td>8.10%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/7/26</td>\n",
       "      <td>5.600</td>\n",
       "      <td>4.36%</td>\n",
       "      <td>3.79%</td>\n",
       "      <td>购买</td>\n",
       "      <td>67.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>凯发电气</th>\n",
       "      <td>123014</td>\n",
       "      <td>凯发转债</td>\n",
       "      <td>92.508</td>\n",
       "      <td>-0.81%</td>\n",
       "      <td>7.21</td>\n",
       "      <td>-1.90%</td>\n",
       "      <td>1.85</td>\n",
       "      <td>8.15</td>\n",
       "      <td>88.83</td>\n",
       "      <td>4.14%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.71</td>\n",
       "      <td>10.6</td>\n",
       "      <td>17.60%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/7/27</td>\n",
       "      <td>4.600</td>\n",
       "      <td>3.79%</td>\n",
       "      <td>3.38%</td>\n",
       "      <td>购买</td>\n",
       "      <td>296.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>利欧股份</th>\n",
       "      <td>128038</td>\n",
       "      <td>利欧转债</td>\n",
       "      <td>91.519</td>\n",
       "      <td>-0.67%</td>\n",
       "      <td>1.51</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>1.10</td>\n",
       "      <td>1.720*</td>\n",
       "      <td>87.79</td>\n",
       "      <td>4.25%</td>\n",
       "      <td>...</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.24</td>\n",
       "      <td>14.60%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/3/22</td>\n",
       "      <td>5.255</td>\n",
       "      <td>4.38%</td>\n",
       "      <td>3.85%</td>\n",
       "      <td>购买</td>\n",
       "      <td>120.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>三一重工</th>\n",
       "      <td>110032</td>\n",
       "      <td>三一转债</td>\n",
       "      <td>121.700</td>\n",
       "      <td>-0.41%</td>\n",
       "      <td>8.46</td>\n",
       "      <td>-0.35%</td>\n",
       "      <td>2.64</td>\n",
       "      <td>7.25</td>\n",
       "      <td>116.55</td>\n",
       "      <td>4.42%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.08</td>\n",
       "      <td>9.43</td>\n",
       "      <td>6.20%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/1/4</td>\n",
       "      <td>3.041</td>\n",
       "      <td>-3.31%</td>\n",
       "      <td>-3.90%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2206.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>常熟银行</th>\n",
       "      <td>113018</td>\n",
       "      <td>常熟转债</td>\n",
       "      <td>111.500</td>\n",
       "      <td>-2.75%</td>\n",
       "      <td>6.15</td>\n",
       "      <td>-3.30%</td>\n",
       "      <td>1.13</td>\n",
       "      <td>5.760*</td>\n",
       "      <td>106.77</td>\n",
       "      <td>4.43%</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>7.49</td>\n",
       "      <td>20.30%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/1/19</td>\n",
       "      <td>5.082</td>\n",
       "      <td>-0.29%</td>\n",
       "      <td>-0.65%</td>\n",
       "      <td>购买</td>\n",
       "      <td>7967.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>科森科技</th>\n",
       "      <td>113521</td>\n",
       "      <td>科森转债</td>\n",
       "      <td>93.250</td>\n",
       "      <td>-0.14%</td>\n",
       "      <td>7.97</td>\n",
       "      <td>0.76%</td>\n",
       "      <td>1.89</td>\n",
       "      <td>8.95</td>\n",
       "      <td>89.05</td>\n",
       "      <td>4.72%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.26</td>\n",
       "      <td>11.63</td>\n",
       "      <td>18.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/16</td>\n",
       "      <td>5.910</td>\n",
       "      <td>3.80%</td>\n",
       "      <td>3.29%</td>\n",
       "      <td>购买</td>\n",
       "      <td>661.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>山鹰纸业</th>\n",
       "      <td>110047</td>\n",
       "      <td>山鹰转债</td>\n",
       "      <td>99.440</td>\n",
       "      <td>-0.46%</td>\n",
       "      <td>3.14</td>\n",
       "      <td>-0.95%</td>\n",
       "      <td>1.19</td>\n",
       "      <td>3.34</td>\n",
       "      <td>94.01</td>\n",
       "      <td>5.77%</td>\n",
       "      <td>...</td>\n",
       "      <td>2.34</td>\n",
       "      <td>4.34</td>\n",
       "      <td>16.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/21</td>\n",
       "      <td>5.923</td>\n",
       "      <td>3.06%</td>\n",
       "      <td>2.49%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2656.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东音股份</th>\n",
       "      <td>128043</td>\n",
       "      <td>东音转债</td>\n",
       "      <td>94.339</td>\n",
       "      <td>-1.22%</td>\n",
       "      <td>10.03</td>\n",
       "      <td>-0.50%</td>\n",
       "      <td>2.29</td>\n",
       "      <td>11.430*</td>\n",
       "      <td>87.75</td>\n",
       "      <td>7.51%</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>14.86</td>\n",
       "      <td>14.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/8/2</td>\n",
       "      <td>5.619</td>\n",
       "      <td>3.74%</td>\n",
       "      <td>3.22%</td>\n",
       "      <td>购买</td>\n",
       "      <td>64.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长久物流</th>\n",
       "      <td>113519</td>\n",
       "      <td>长久转债</td>\n",
       "      <td>98.800</td>\n",
       "      <td>0.24%</td>\n",
       "      <td>10.98</td>\n",
       "      <td>-2.23%</td>\n",
       "      <td>2.74</td>\n",
       "      <td>11.99</td>\n",
       "      <td>91.58</td>\n",
       "      <td>7.89%</td>\n",
       "      <td>...</td>\n",
       "      <td>8.39</td>\n",
       "      <td>15.59</td>\n",
       "      <td>11.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/7</td>\n",
       "      <td>5.885</td>\n",
       "      <td>3.52%</td>\n",
       "      <td>2.88%</td>\n",
       "      <td>购买</td>\n",
       "      <td>318.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张家港行</th>\n",
       "      <td>128048</td>\n",
       "      <td>张行转债</td>\n",
       "      <td>100.270</td>\n",
       "      <td>-0.33%</td>\n",
       "      <td>5.61</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>1.13</td>\n",
       "      <td>6.06</td>\n",
       "      <td>92.57</td>\n",
       "      <td>8.31%</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>7.88</td>\n",
       "      <td>24.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/12</td>\n",
       "      <td>5.899</td>\n",
       "      <td>2.29%</td>\n",
       "      <td>1.83%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1629.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>洲明科技</th>\n",
       "      <td>123016</td>\n",
       "      <td>洲明转债</td>\n",
       "      <td>99.120</td>\n",
       "      <td>-0.58%</td>\n",
       "      <td>8.63</td>\n",
       "      <td>-1.03%</td>\n",
       "      <td>3.13</td>\n",
       "      <td>9.45</td>\n",
       "      <td>91.43</td>\n",
       "      <td>8.41%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.62</td>\n",
       "      <td>12.29</td>\n",
       "      <td>8.30%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/7</td>\n",
       "      <td>5.885</td>\n",
       "      <td>2.74%</td>\n",
       "      <td>2.24%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1051.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>圆通速递</th>\n",
       "      <td>110046</td>\n",
       "      <td>圆通转债</td>\n",
       "      <td>101.690</td>\n",
       "      <td>-0.23%</td>\n",
       "      <td>10.19</td>\n",
       "      <td>-0.49%</td>\n",
       "      <td>2.80</td>\n",
       "      <td>10.89</td>\n",
       "      <td>93.76</td>\n",
       "      <td>8.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>7.62</td>\n",
       "      <td>14.16</td>\n",
       "      <td>12.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/11/19</td>\n",
       "      <td>5.918</td>\n",
       "      <td>2.24%</td>\n",
       "      <td>1.75%</td>\n",
       "      <td>购买</td>\n",
       "      <td>4640.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>江阴银行</th>\n",
       "      <td>128034</td>\n",
       "      <td>江银转债</td>\n",
       "      <td>99.000</td>\n",
       "      <td>-0.38%</td>\n",
       "      <td>5.17</td>\n",
       "      <td>-0.77%</td>\n",
       "      <td>0.91</td>\n",
       "      <td>5.670**</td>\n",
       "      <td>91.01</td>\n",
       "      <td>8.78%</td>\n",
       "      <td>...</td>\n",
       "      <td>-</td>\n",
       "      <td>7.37</td>\n",
       "      <td>21.90%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/1/26</td>\n",
       "      <td>5.101</td>\n",
       "      <td>2.10%</td>\n",
       "      <td>1.73%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1465.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方财富</th>\n",
       "      <td>123006</td>\n",
       "      <td>东财转债</td>\n",
       "      <td>119.900</td>\n",
       "      <td>-1.32%</td>\n",
       "      <td>12.50</td>\n",
       "      <td>-1.65%</td>\n",
       "      <td>4.16</td>\n",
       "      <td>11.36</td>\n",
       "      <td>110.12</td>\n",
       "      <td>8.88%</td>\n",
       "      <td>...</td>\n",
       "      <td>7.95</td>\n",
       "      <td>14.77</td>\n",
       "      <td>7.20%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/20</td>\n",
       "      <td>5.000</td>\n",
       "      <td>-1.64%</td>\n",
       "      <td>-2.02%</td>\n",
       "      <td>购买</td>\n",
       "      <td>8578.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>崇达技术</th>\n",
       "      <td>128027</td>\n",
       "      <td>崇达转债</td>\n",
       "      <td>104.660</td>\n",
       "      <td>-1.36%</td>\n",
       "      <td>14.46</td>\n",
       "      <td>-0.07%</td>\n",
       "      <td>4.33</td>\n",
       "      <td>15.11</td>\n",
       "      <td>95.50</td>\n",
       "      <td>9.59%</td>\n",
       "      <td>...</td>\n",
       "      <td>10.58</td>\n",
       "      <td>19.64</td>\n",
       "      <td>6.50%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/15</td>\n",
       "      <td>4.986</td>\n",
       "      <td>1.17%</td>\n",
       "      <td>0.76%</td>\n",
       "      <td>购买</td>\n",
       "      <td>100.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>康泰生物</th>\n",
       "      <td>123008</td>\n",
       "      <td>康泰转债</td>\n",
       "      <td>122.149</td>\n",
       "      <td>-2.93%</td>\n",
       "      <td>34.50</td>\n",
       "      <td>-2.49%</td>\n",
       "      <td>13.40</td>\n",
       "      <td>31.23</td>\n",
       "      <td>110.47</td>\n",
       "      <td>10.57%</td>\n",
       "      <td>...</td>\n",
       "      <td>21.86</td>\n",
       "      <td>40.6</td>\n",
       "      <td>1.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/2/1</td>\n",
       "      <td>5.118</td>\n",
       "      <td>-1.87%</td>\n",
       "      <td>-2.26%</td>\n",
       "      <td>购买</td>\n",
       "      <td>737.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>金禾实业</th>\n",
       "      <td>128017</td>\n",
       "      <td>金禾转债</td>\n",
       "      <td>100.801</td>\n",
       "      <td>-0.20%</td>\n",
       "      <td>15.67</td>\n",
       "      <td>-0.51%</td>\n",
       "      <td>2.33</td>\n",
       "      <td>23.32</td>\n",
       "      <td>67.20</td>\n",
       "      <td>50.01%</td>\n",
       "      <td>...</td>\n",
       "      <td>16.32</td>\n",
       "      <td>30.32</td>\n",
       "      <td>6.90%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/11/1</td>\n",
       "      <td>4.866</td>\n",
       "      <td>1.90%</td>\n",
       "      <td>1.50%</td>\n",
       "      <td>购买</td>\n",
       "      <td>5.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>双环传动</th>\n",
       "      <td>128032</td>\n",
       "      <td>双环转债</td>\n",
       "      <td>91.968</td>\n",
       "      <td>-0.42%</td>\n",
       "      <td>6.08</td>\n",
       "      <td>-1.46%</td>\n",
       "      <td>1.18</td>\n",
       "      <td>9.99</td>\n",
       "      <td>60.86</td>\n",
       "      <td>51.11%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.99</td>\n",
       "      <td>12.99</td>\n",
       "      <td>24.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/25</td>\n",
       "      <td>5.014</td>\n",
       "      <td>3.93%</td>\n",
       "      <td>3.49%</td>\n",
       "      <td>购买</td>\n",
       "      <td>172.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>太阳纸业</th>\n",
       "      <td>128029</td>\n",
       "      <td>太阳转债</td>\n",
       "      <td>99.939</td>\n",
       "      <td>-0.02%</td>\n",
       "      <td>5.78</td>\n",
       "      <td>-0.69%</td>\n",
       "      <td>1.24</td>\n",
       "      <td>8.75</td>\n",
       "      <td>65.94</td>\n",
       "      <td>51.55%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.12</td>\n",
       "      <td>11.38</td>\n",
       "      <td>8.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/12/22</td>\n",
       "      <td>4.005</td>\n",
       "      <td>2.12%</td>\n",
       "      <td>1.71%</td>\n",
       "      <td>购买</td>\n",
       "      <td>116.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>铁汉生态</th>\n",
       "      <td>123004</td>\n",
       "      <td>铁汉转债</td>\n",
       "      <td>89.186</td>\n",
       "      <td>-2.09%</td>\n",
       "      <td>4.83</td>\n",
       "      <td>-10.06%</td>\n",
       "      <td>1.71</td>\n",
       "      <td>8.23</td>\n",
       "      <td>58.69</td>\n",
       "      <td>51.97%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.76</td>\n",
       "      <td>10.7</td>\n",
       "      <td>10.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/18</td>\n",
       "      <td>4.995</td>\n",
       "      <td>4.42%</td>\n",
       "      <td>4.01%</td>\n",
       "      <td>购买</td>\n",
       "      <td>15820.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>千禾味业</th>\n",
       "      <td>113511</td>\n",
       "      <td>千禾转债</td>\n",
       "      <td>93.030</td>\n",
       "      <td>-0.23%</td>\n",
       "      <td>15.58</td>\n",
       "      <td>-1.14%</td>\n",
       "      <td>3.99</td>\n",
       "      <td>25.85</td>\n",
       "      <td>60.27</td>\n",
       "      <td>54.35%</td>\n",
       "      <td>...</td>\n",
       "      <td>18.09</td>\n",
       "      <td>33.6</td>\n",
       "      <td>7.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/6/19</td>\n",
       "      <td>5.499</td>\n",
       "      <td>3.69%</td>\n",
       "      <td>3.23%</td>\n",
       "      <td>购买</td>\n",
       "      <td>83.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方雨虹</th>\n",
       "      <td>128016</td>\n",
       "      <td>雨虹转债</td>\n",
       "      <td>97.727</td>\n",
       "      <td>-0.93%</td>\n",
       "      <td>14.23</td>\n",
       "      <td>-2.80%</td>\n",
       "      <td>2.73</td>\n",
       "      <td>22.63</td>\n",
       "      <td>62.84</td>\n",
       "      <td>55.52%</td>\n",
       "      <td>...</td>\n",
       "      <td>15.84</td>\n",
       "      <td>29.42</td>\n",
       "      <td>8.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/9/25</td>\n",
       "      <td>4.764</td>\n",
       "      <td>2.62%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>购买</td>\n",
       "      <td>408.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>众兴菌业</th>\n",
       "      <td>128026</td>\n",
       "      <td>众兴转债</td>\n",
       "      <td>87.115</td>\n",
       "      <td>-0.71%</td>\n",
       "      <td>6.51</td>\n",
       "      <td>-1.06%</td>\n",
       "      <td>0.89</td>\n",
       "      <td>11.64</td>\n",
       "      <td>55.93</td>\n",
       "      <td>55.76%</td>\n",
       "      <td>...</td>\n",
       "      <td>8.15</td>\n",
       "      <td>15.13</td>\n",
       "      <td>37.80%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/13</td>\n",
       "      <td>4.981</td>\n",
       "      <td>5.07%</td>\n",
       "      <td>4.62%</td>\n",
       "      <td>购买</td>\n",
       "      <td>545.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>众信旅游</th>\n",
       "      <td>128022</td>\n",
       "      <td>众信转债</td>\n",
       "      <td>93.061</td>\n",
       "      <td>-0.48%</td>\n",
       "      <td>6.45</td>\n",
       "      <td>-2.27%</td>\n",
       "      <td>2.28</td>\n",
       "      <td>11</td>\n",
       "      <td>58.64</td>\n",
       "      <td>58.71%</td>\n",
       "      <td>...</td>\n",
       "      <td>7.7</td>\n",
       "      <td>14.3</td>\n",
       "      <td>12.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/1</td>\n",
       "      <td>4.948</td>\n",
       "      <td>3.56%</td>\n",
       "      <td>3.15%</td>\n",
       "      <td>购买</td>\n",
       "      <td>7.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>久其软件</th>\n",
       "      <td>128015</td>\n",
       "      <td>久其转债</td>\n",
       "      <td>92.051</td>\n",
       "      <td>-0.70%</td>\n",
       "      <td>7.38</td>\n",
       "      <td>0.68%</td>\n",
       "      <td>2.47</td>\n",
       "      <td>12.86</td>\n",
       "      <td>57.31</td>\n",
       "      <td>60.62%</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>16.72</td>\n",
       "      <td>14.90%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/6/8</td>\n",
       "      <td>4.466</td>\n",
       "      <td>4.64%</td>\n",
       "      <td>4.10%</td>\n",
       "      <td>购买</td>\n",
       "      <td>153.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中化岩土</th>\n",
       "      <td>128037</td>\n",
       "      <td>岩土转债</td>\n",
       "      <td>87.830</td>\n",
       "      <td>-0.64%</td>\n",
       "      <td>4.36</td>\n",
       "      <td>-1.58%</td>\n",
       "      <td>2.10</td>\n",
       "      <td>8.03</td>\n",
       "      <td>54.30</td>\n",
       "      <td>61.76%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.62</td>\n",
       "      <td>10.44</td>\n",
       "      <td>7.60%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/3/15</td>\n",
       "      <td>5.236</td>\n",
       "      <td>5.05%</td>\n",
       "      <td>4.56%</td>\n",
       "      <td>购买</td>\n",
       "      <td>136.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>江南水务</th>\n",
       "      <td>113010</td>\n",
       "      <td>江南转债</td>\n",
       "      <td>102.100</td>\n",
       "      <td>-0.49%</td>\n",
       "      <td>3.67</td>\n",
       "      <td>-0.54%</td>\n",
       "      <td>1.27</td>\n",
       "      <td>6.020*</td>\n",
       "      <td>60.96</td>\n",
       "      <td>67.48%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.82</td>\n",
       "      <td>7.83</td>\n",
       "      <td>1.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/3/18</td>\n",
       "      <td>3.241</td>\n",
       "      <td>3.05%</td>\n",
       "      <td>2.32%</td>\n",
       "      <td>购买</td>\n",
       "      <td>330.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>林洋能源</th>\n",
       "      <td>113014</td>\n",
       "      <td>林洋转债</td>\n",
       "      <td>94.800</td>\n",
       "      <td>-0.66%</td>\n",
       "      <td>4.94</td>\n",
       "      <td>0.82%</td>\n",
       "      <td>0.88</td>\n",
       "      <td>8.76</td>\n",
       "      <td>56.51</td>\n",
       "      <td>67.77%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.13</td>\n",
       "      <td>11.39</td>\n",
       "      <td>34.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/10/27</td>\n",
       "      <td>4.852</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>2.89%</td>\n",
       "      <td>购买</td>\n",
       "      <td>416.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>道氏技术</th>\n",
       "      <td>123007</td>\n",
       "      <td>道氏转债</td>\n",
       "      <td>97.150</td>\n",
       "      <td>-1.26%</td>\n",
       "      <td>14.37</td>\n",
       "      <td>-3.23%</td>\n",
       "      <td>3.99</td>\n",
       "      <td>24.88</td>\n",
       "      <td>57.68</td>\n",
       "      <td>68.44%</td>\n",
       "      <td>...</td>\n",
       "      <td>17.42</td>\n",
       "      <td>32.34</td>\n",
       "      <td>7.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/28</td>\n",
       "      <td>5.022</td>\n",
       "      <td>3.04%</td>\n",
       "      <td>2.56%</td>\n",
       "      <td>购买</td>\n",
       "      <td>779.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天康生物</th>\n",
       "      <td>128030</td>\n",
       "      <td>天康转债</td>\n",
       "      <td>91.000</td>\n",
       "      <td>-1.62%</td>\n",
       "      <td>4.38</td>\n",
       "      <td>-2.23%</td>\n",
       "      <td>1.34</td>\n",
       "      <td>8.15</td>\n",
       "      <td>53.74</td>\n",
       "      <td>69.33%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.71</td>\n",
       "      <td>10.6</td>\n",
       "      <td>23.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/22</td>\n",
       "      <td>5.005</td>\n",
       "      <td>4.54%</td>\n",
       "      <td>4.02%</td>\n",
       "      <td>购买</td>\n",
       "      <td>115.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大族激光</th>\n",
       "      <td>128035</td>\n",
       "      <td>大族转债</td>\n",
       "      <td>98.780</td>\n",
       "      <td>-0.42%</td>\n",
       "      <td>30.04</td>\n",
       "      <td>0.64%</td>\n",
       "      <td>3.67</td>\n",
       "      <td>52.5</td>\n",
       "      <td>57.09</td>\n",
       "      <td>73.04%</td>\n",
       "      <td>...</td>\n",
       "      <td>36.75</td>\n",
       "      <td>68.25</td>\n",
       "      <td>7.20%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2024/2/6</td>\n",
       "      <td>5.132</td>\n",
       "      <td>1.89%</td>\n",
       "      <td>1.56%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1181.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>赣锋锂业</th>\n",
       "      <td>128028</td>\n",
       "      <td>赣锋转债</td>\n",
       "      <td>96.100</td>\n",
       "      <td>-1.13%</td>\n",
       "      <td>23.09</td>\n",
       "      <td>-4.55%</td>\n",
       "      <td>6.17</td>\n",
       "      <td>42.58</td>\n",
       "      <td>54.20</td>\n",
       "      <td>77.29%</td>\n",
       "      <td>...</td>\n",
       "      <td>29.81</td>\n",
       "      <td>55.35</td>\n",
       "      <td>3.10%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/21</td>\n",
       "      <td>5.000</td>\n",
       "      <td>2.74%</td>\n",
       "      <td>2.36%</td>\n",
       "      <td>购买</td>\n",
       "      <td>293.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>嘉澳环保</th>\n",
       "      <td>113502</td>\n",
       "      <td>嘉澳转债</td>\n",
       "      <td>89.390</td>\n",
       "      <td>-0.32%</td>\n",
       "      <td>22.48</td>\n",
       "      <td>-1.49%</td>\n",
       "      <td>2.20</td>\n",
       "      <td>45.27</td>\n",
       "      <td>49.66</td>\n",
       "      <td>80.01%</td>\n",
       "      <td>...</td>\n",
       "      <td>31.69</td>\n",
       "      <td>58.85</td>\n",
       "      <td>11.20%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/11/9</td>\n",
       "      <td>4.888</td>\n",
       "      <td>4.99%</td>\n",
       "      <td>4.47%</td>\n",
       "      <td>购买</td>\n",
       "      <td>35.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>格力地产</th>\n",
       "      <td>110030</td>\n",
       "      <td>格力转债</td>\n",
       "      <td>103.510</td>\n",
       "      <td>-0.12%</td>\n",
       "      <td>3.96</td>\n",
       "      <td>-1.98%</td>\n",
       "      <td>1.08</td>\n",
       "      <td>6.94</td>\n",
       "      <td>57.06</td>\n",
       "      <td>81.40%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.86</td>\n",
       "      <td>9.02</td>\n",
       "      <td>5.20%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2019/12/25</td>\n",
       "      <td>1.011</td>\n",
       "      <td>3.87%</td>\n",
       "      <td>2.41%</td>\n",
       "      <td>购买</td>\n",
       "      <td>423.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新时达</th>\n",
       "      <td>128018</td>\n",
       "      <td>时达转债</td>\n",
       "      <td>87.400</td>\n",
       "      <td>-0.24%</td>\n",
       "      <td>5.49</td>\n",
       "      <td>-1.96%</td>\n",
       "      <td>1.13</td>\n",
       "      <td>11.83</td>\n",
       "      <td>46.32</td>\n",
       "      <td>88.68%</td>\n",
       "      <td>...</td>\n",
       "      <td>8.28</td>\n",
       "      <td>15.38</td>\n",
       "      <td>25.90%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/11/6</td>\n",
       "      <td>4.879</td>\n",
       "      <td>5.08%</td>\n",
       "      <td>4.63%</td>\n",
       "      <td>购买</td>\n",
       "      <td>414.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>凤凰传媒</th>\n",
       "      <td>132007</td>\n",
       "      <td>16凤凰EBQ</td>\n",
       "      <td>96.350</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>7.68</td>\n",
       "      <td>0.79%</td>\n",
       "      <td>1.49</td>\n",
       "      <td>15.36</td>\n",
       "      <td>50.07</td>\n",
       "      <td>92.73%</td>\n",
       "      <td>...</td>\n",
       "      <td>12.29</td>\n",
       "      <td>19.97</td>\n",
       "      <td>25.60%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2021/10/31</td>\n",
       "      <td>2.863</td>\n",
       "      <td>4.05%</td>\n",
       "      <td>3.50%</td>\n",
       "      <td>购买</td>\n",
       "      <td>29.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>航天信息</th>\n",
       "      <td>110031</td>\n",
       "      <td>航信转债</td>\n",
       "      <td>106.310</td>\n",
       "      <td>-0.18%</td>\n",
       "      <td>22.75</td>\n",
       "      <td>-0.13%</td>\n",
       "      <td>4.09</td>\n",
       "      <td>42.38</td>\n",
       "      <td>53.66</td>\n",
       "      <td>98.13%</td>\n",
       "      <td>...</td>\n",
       "      <td>29.67</td>\n",
       "      <td>55.09</td>\n",
       "      <td>5.70%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2021/6/12</td>\n",
       "      <td>2.477</td>\n",
       "      <td>1.41%</td>\n",
       "      <td>0.65%</td>\n",
       "      <td>购买</td>\n",
       "      <td>204.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海建工</th>\n",
       "      <td>132004</td>\n",
       "      <td>15国盛EB</td>\n",
       "      <td>96.760</td>\n",
       "      <td>-0.03%</td>\n",
       "      <td>3.05</td>\n",
       "      <td>-0.65%</td>\n",
       "      <td>0.95</td>\n",
       "      <td>6.48</td>\n",
       "      <td>47.07</td>\n",
       "      <td>105.85%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.54</td>\n",
       "      <td>8.42</td>\n",
       "      <td>18.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2021/11/5</td>\n",
       "      <td>2.877</td>\n",
       "      <td>3.21%</td>\n",
       "      <td>2.79%</td>\n",
       "      <td>购买</td>\n",
       "      <td>809.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蓝思科技</th>\n",
       "      <td>123003</td>\n",
       "      <td>蓝思转债</td>\n",
       "      <td>90.200</td>\n",
       "      <td>-0.24%</td>\n",
       "      <td>7.00</td>\n",
       "      <td>-0.43%</td>\n",
       "      <td>1.59</td>\n",
       "      <td>16.080*</td>\n",
       "      <td>43.53</td>\n",
       "      <td>107.20%</td>\n",
       "      <td>...</td>\n",
       "      <td>11.26</td>\n",
       "      <td>20.9</td>\n",
       "      <td>17.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/8</td>\n",
       "      <td>4.967</td>\n",
       "      <td>4.21%</td>\n",
       "      <td>3.79%</td>\n",
       "      <td>购买</td>\n",
       "      <td>351.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>亚太股份</th>\n",
       "      <td>128023</td>\n",
       "      <td>亚太转债</td>\n",
       "      <td>88.020</td>\n",
       "      <td>-0.22%</td>\n",
       "      <td>4.35</td>\n",
       "      <td>-2.25%</td>\n",
       "      <td>1.14</td>\n",
       "      <td>10.34</td>\n",
       "      <td>41.88</td>\n",
       "      <td>110.19%</td>\n",
       "      <td>...</td>\n",
       "      <td>7.24</td>\n",
       "      <td>13.44</td>\n",
       "      <td>31.20%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/12/8</td>\n",
       "      <td>4.967</td>\n",
       "      <td>5.22%</td>\n",
       "      <td>4.71%</td>\n",
       "      <td>购买</td>\n",
       "      <td>469.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>山东高速</th>\n",
       "      <td>132008</td>\n",
       "      <td>17山高EB</td>\n",
       "      <td>98.350</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>4.47</td>\n",
       "      <td>-0.89%</td>\n",
       "      <td>0.76</td>\n",
       "      <td>9.62</td>\n",
       "      <td>46.47</td>\n",
       "      <td>114.09%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.73</td>\n",
       "      <td>12.51</td>\n",
       "      <td>11.60%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/4/24</td>\n",
       "      <td>3.342</td>\n",
       "      <td>3.95%</td>\n",
       "      <td>3.20%</td>\n",
       "      <td>购买</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>模塑科技</th>\n",
       "      <td>127004</td>\n",
       "      <td>模塑转债</td>\n",
       "      <td>87.500</td>\n",
       "      <td>0.09%</td>\n",
       "      <td>3.04</td>\n",
       "      <td>-1.94%</td>\n",
       "      <td>0.99</td>\n",
       "      <td>7.72</td>\n",
       "      <td>39.64</td>\n",
       "      <td>120.75%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.4</td>\n",
       "      <td>10.04</td>\n",
       "      <td>32.40%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2023/6/2</td>\n",
       "      <td>4.449</td>\n",
       "      <td>6.49%</td>\n",
       "      <td>5.82%</td>\n",
       "      <td>购买</td>\n",
       "      <td>159.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>澳洋顺昌</th>\n",
       "      <td>128010</td>\n",
       "      <td>顺昌转债</td>\n",
       "      <td>97.801</td>\n",
       "      <td>-0.20%</td>\n",
       "      <td>4.01</td>\n",
       "      <td>-2.43%</td>\n",
       "      <td>1.48</td>\n",
       "      <td>9.28</td>\n",
       "      <td>43.21</td>\n",
       "      <td>126.33%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.5</td>\n",
       "      <td>12.06</td>\n",
       "      <td>12.90%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/1/22</td>\n",
       "      <td>3.090</td>\n",
       "      <td>4.66%</td>\n",
       "      <td>3.88%</td>\n",
       "      <td>购买</td>\n",
       "      <td>104.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>浙数文化</th>\n",
       "      <td>132011</td>\n",
       "      <td>17浙报EBQ</td>\n",
       "      <td>91.610</td>\n",
       "      <td>-0.21%</td>\n",
       "      <td>8.33</td>\n",
       "      <td>0.60%</td>\n",
       "      <td>1.37</td>\n",
       "      <td>24.39</td>\n",
       "      <td>34.11</td>\n",
       "      <td>169.57%</td>\n",
       "      <td>...</td>\n",
       "      <td>17.07</td>\n",
       "      <td>31.71</td>\n",
       "      <td>22.10%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/8/17</td>\n",
       "      <td>3.658</td>\n",
       "      <td>4.03%</td>\n",
       "      <td>3.69%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1036.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>洪涛股份</th>\n",
       "      <td>128013</td>\n",
       "      <td>洪涛转债</td>\n",
       "      <td>88.900</td>\n",
       "      <td>0.02%</td>\n",
       "      <td>3.00</td>\n",
       "      <td>-0.99%</td>\n",
       "      <td>0.99</td>\n",
       "      <td>9.98</td>\n",
       "      <td>30.06</td>\n",
       "      <td>195.74%</td>\n",
       "      <td>...</td>\n",
       "      <td>6.99</td>\n",
       "      <td>12.97</td>\n",
       "      <td>32.00%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/7/29</td>\n",
       "      <td>3.605</td>\n",
       "      <td>6.84%</td>\n",
       "      <td>6.15%</td>\n",
       "      <td>购买</td>\n",
       "      <td>233.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ST辉丰</th>\n",
       "      <td>128012</td>\n",
       "      <td>辉丰转债</td>\n",
       "      <td>79.761</td>\n",
       "      <td>-1.15%</td>\n",
       "      <td>2.06</td>\n",
       "      <td>-0.96%</td>\n",
       "      <td>0.89</td>\n",
       "      <td>7.71</td>\n",
       "      <td>26.59</td>\n",
       "      <td>199.98%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.4</td>\n",
       "      <td>10.02</td>\n",
       "      <td>27.20%</td>\n",
       "      <td>会员</td>\n",
       "      <td>2022/4/21</td>\n",
       "      <td>3.334</td>\n",
       "      <td>9.30%</td>\n",
       "      <td>8.84%</td>\n",
       "      <td>购买</td>\n",
       "      <td>531.51</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>113 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            bond_code bond_name  bond_price bond_x1  stock_price stock_x1  \\\n",
       "stock_name                                                                  \n",
       "广电网络           110044      广电转债      98.990   0.55%         7.06    3.67%   \n",
       "德尔股份           123011      德尔转债      97.880  -0.02%        35.14   -0.03%   \n",
       "盛路通信           128041      盛路转债      99.670  -0.16%         7.06   -0.14%   \n",
       "鼎信通讯           113506      鼎信转债     105.980   0.26%        23.41   -1.72%   \n",
       "梦百合            113520      百合转债     101.690   1.99%        19.68    3.47%   \n",
       "华源控股           128049      华源转债      92.120  -1.17%         7.07    0.00%   \n",
       "万顺股份           123012      万顺转债      95.100  -1.59%         6.22   -2.66%   \n",
       "小康股份           113016      小康转债      97.920  -0.10%        16.87   -0.24%   \n",
       "旭升股份           113522      旭升转债     102.150   0.23%        30.18    0.90%   \n",
       "三力士            128039      三力转债      96.066  -0.42%         5.52   -1.60%   \n",
       "蓝盾股份           123015      蓝盾转债      92.280  -0.02%         5.25    0.77%   \n",
       "吴江银行           113516      吴银转债     104.640  -0.91%         6.45   -2.42%   \n",
       "国祯环保           123002      国祯转债     107.500  -0.01%         9.04   -0.11%   \n",
       "安井食品           113513      安井转债     106.600  -0.27%        36.50   -0.73%   \n",
       "横河模具           123013      横河转债      92.295  -0.22%         8.25    0.12%   \n",
       "凯发电气           123014      凯发转债      92.508  -0.81%         7.21   -1.90%   \n",
       "利欧股份           128038      利欧转债      91.519  -0.67%         1.51    0.00%   \n",
       "三一重工           110032      三一转债     121.700  -0.41%         8.46   -0.35%   \n",
       "常熟银行           113018      常熟转债     111.500  -2.75%         6.15   -3.30%   \n",
       "科森科技           113521      科森转债      93.250  -0.14%         7.97    0.76%   \n",
       "山鹰纸业           110047      山鹰转债      99.440  -0.46%         3.14   -0.95%   \n",
       "东音股份           128043      东音转债      94.339  -1.22%        10.03   -0.50%   \n",
       "长久物流           113519      长久转债      98.800   0.24%        10.98   -2.23%   \n",
       "张家港行           128048      张行转债     100.270  -0.33%         5.61    0.00%   \n",
       "洲明科技           123016      洲明转债      99.120  -0.58%         8.63   -1.03%   \n",
       "圆通速递           110046      圆通转债     101.690  -0.23%        10.19   -0.49%   \n",
       "江阴银行           128034      江银转债      99.000  -0.38%         5.17   -0.77%   \n",
       "东方财富           123006      东财转债     119.900  -1.32%        12.50   -1.65%   \n",
       "崇达技术           128027      崇达转债     104.660  -1.36%        14.46   -0.07%   \n",
       "康泰生物           123008      康泰转债     122.149  -2.93%        34.50   -2.49%   \n",
       "...               ...       ...         ...     ...          ...      ...   \n",
       "金禾实业           128017      金禾转债     100.801  -0.20%        15.67   -0.51%   \n",
       "双环传动           128032      双环转债      91.968  -0.42%         6.08   -1.46%   \n",
       "太阳纸业           128029      太阳转债      99.939  -0.02%         5.78   -0.69%   \n",
       "铁汉生态           123004      铁汉转债      89.186  -2.09%         4.83  -10.06%   \n",
       "千禾味业           113511      千禾转债      93.030  -0.23%        15.58   -1.14%   \n",
       "东方雨虹           128016      雨虹转债      97.727  -0.93%        14.23   -2.80%   \n",
       "众兴菌业           128026      众兴转债      87.115  -0.71%         6.51   -1.06%   \n",
       "众信旅游           128022      众信转债      93.061  -0.48%         6.45   -2.27%   \n",
       "久其软件           128015      久其转债      92.051  -0.70%         7.38    0.68%   \n",
       "中化岩土           128037      岩土转债      87.830  -0.64%         4.36   -1.58%   \n",
       "江南水务           113010      江南转债     102.100  -0.49%         3.67   -0.54%   \n",
       "林洋能源           113014      林洋转债      94.800  -0.66%         4.94    0.82%   \n",
       "道氏技术           123007      道氏转债      97.150  -1.26%        14.37   -3.23%   \n",
       "天康生物           128030      天康转债      91.000  -1.62%         4.38   -2.23%   \n",
       "大族激光           128035      大族转债      98.780  -0.42%        30.04    0.64%   \n",
       "赣锋锂业           128028      赣锋转债      96.100  -1.13%        23.09   -4.55%   \n",
       "嘉澳环保           113502      嘉澳转债      89.390  -0.32%        22.48   -1.49%   \n",
       "格力地产           110030      格力转债     103.510  -0.12%         3.96   -1.98%   \n",
       "新时达            128018      时达转债      87.400  -0.24%         5.49   -1.96%   \n",
       "凤凰传媒           132007   16凤凰EBQ      96.350   0.00%         7.68    0.79%   \n",
       "航天信息           110031      航信转债     106.310  -0.18%        22.75   -0.13%   \n",
       "上海建工           132004    15国盛EB      96.760  -0.03%         3.05   -0.65%   \n",
       "蓝思科技           123003      蓝思转债      90.200  -0.24%         7.00   -0.43%   \n",
       "亚太股份           128023      亚太转债      88.020  -0.22%         4.35   -2.25%   \n",
       "山东高速           132008    17山高EB      98.350   0.00%         4.47   -0.89%   \n",
       "模塑科技           127004      模塑转债      87.500   0.09%         3.04   -1.94%   \n",
       "澳洋顺昌           128010      顺昌转债      97.801  -0.20%         4.01   -2.43%   \n",
       "浙数文化           132011   17浙报EBQ      91.610  -0.21%         8.33    0.60%   \n",
       "洪涛股份           128013      洪涛转债      88.900   0.02%         3.00   -0.99%   \n",
       "ST辉丰           128012      辉丰转债      79.761  -1.15%         2.06   -0.96%   \n",
       "\n",
       "               pb convert_price  convert_value  premium    ...     \\\n",
       "stock_name                                                 ...      \n",
       "广电网络         1.34          6.91         102.03   -2.98%    ...      \n",
       "德尔股份         1.90         34.96         100.74   -2.84%    ...      \n",
       "盛路通信         1.90          6.88         102.47   -2.73%    ...      \n",
       "鼎信通讯         4.28         21.65         108.36   -2.20%    ...      \n",
       "梦百合          2.88         19.03         103.47   -1.72%    ...      \n",
       "华源控股         1.62          7.58          93.40   -1.37%    ...      \n",
       "万顺股份         1.02          6.47          95.83   -0.76%    ...      \n",
       "小康股份         3.18       17.200*          98.08   -0.16%    ...      \n",
       "旭升股份         9.00         29.86         101.14    1.00%    ...      \n",
       "三力士          1.90        5.840*          94.52    1.64%    ...      \n",
       "蓝盾股份         1.44        5.820*          90.03    2.49%    ...      \n",
       "吴江银行         1.01          6.34         101.74    2.86%    ...      \n",
       "国祯环保         2.29        8.720*         103.90    3.47%    ...      \n",
       "安井食品         3.99         35.46         102.88    3.62%    ...      \n",
       "横河模具         4.22          9.26          88.98    3.72%    ...      \n",
       "凯发电气         1.85          8.15          88.83    4.14%    ...      \n",
       "利欧股份         1.10        1.720*          87.79    4.25%    ...      \n",
       "三一重工         2.64          7.25         116.55    4.42%    ...      \n",
       "常熟银行         1.13        5.760*         106.77    4.43%    ...      \n",
       "科森科技         1.89          8.95          89.05    4.72%    ...      \n",
       "山鹰纸业         1.19          3.34          94.01    5.77%    ...      \n",
       "东音股份         2.29       11.430*          87.75    7.51%    ...      \n",
       "长久物流         2.74         11.99          91.58    7.89%    ...      \n",
       "张家港行         1.13          6.06          92.57    8.31%    ...      \n",
       "洲明科技         3.13          9.45          91.43    8.41%    ...      \n",
       "圆通速递         2.80         10.89          93.76    8.46%    ...      \n",
       "江阴银行         0.91       5.670**          91.01    8.78%    ...      \n",
       "东方财富         4.16         11.36         110.12    8.88%    ...      \n",
       "崇达技术         4.33         15.11          95.50    9.59%    ...      \n",
       "康泰生物        13.40         31.23         110.47   10.57%    ...      \n",
       "...           ...           ...            ...      ...    ...      \n",
       "金禾实业         2.33         23.32          67.20   50.01%    ...      \n",
       "双环传动         1.18          9.99          60.86   51.11%    ...      \n",
       "太阳纸业         1.24          8.75          65.94   51.55%    ...      \n",
       "铁汉生态         1.71          8.23          58.69   51.97%    ...      \n",
       "千禾味业         3.99         25.85          60.27   54.35%    ...      \n",
       "东方雨虹         2.73         22.63          62.84   55.52%    ...      \n",
       "众兴菌业         0.89         11.64          55.93   55.76%    ...      \n",
       "众信旅游         2.28            11          58.64   58.71%    ...      \n",
       "久其软件         2.47         12.86          57.31   60.62%    ...      \n",
       "中化岩土         2.10          8.03          54.30   61.76%    ...      \n",
       "江南水务         1.27        6.020*          60.96   67.48%    ...      \n",
       "林洋能源         0.88          8.76          56.51   67.77%    ...      \n",
       "道氏技术         3.99         24.88          57.68   68.44%    ...      \n",
       "天康生物         1.34          8.15          53.74   69.33%    ...      \n",
       "大族激光         3.67          52.5          57.09   73.04%    ...      \n",
       "赣锋锂业         6.17         42.58          54.20   77.29%    ...      \n",
       "嘉澳环保         2.20         45.27          49.66   80.01%    ...      \n",
       "格力地产         1.08          6.94          57.06   81.40%    ...      \n",
       "新时达          1.13         11.83          46.32   88.68%    ...      \n",
       "凤凰传媒         1.49         15.36          50.07   92.73%    ...      \n",
       "航天信息         4.09         42.38          53.66   98.13%    ...      \n",
       "上海建工         0.95          6.48          47.07  105.85%    ...      \n",
       "蓝思科技         1.59       16.080*          43.53  107.20%    ...      \n",
       "亚太股份         1.14         10.34          41.88  110.19%    ...      \n",
       "山东高速         0.76          9.62          46.47  114.09%    ...      \n",
       "模塑科技         0.99          7.72          39.64  120.75%    ...      \n",
       "澳洋顺昌         1.48          9.28          43.21  126.33%    ...      \n",
       "浙数文化         1.37         24.39          34.11  169.57%    ...      \n",
       "洪涛股份         0.99          9.98          30.06  195.74%    ...      \n",
       "ST辉丰         0.89          7.71          26.59  199.98%    ...      \n",
       "\n",
       "           shuishou_price qiangshu_price bond_x2 bond_x3      expire   year  \\\n",
       "stock_name                                                                    \n",
       "广电网络                 4.84           8.98  18.70%      会员   2024/6/27  5.521   \n",
       "德尔股份                24.47          45.45  15.30%      会员   2024/7/18  5.578   \n",
       "盛路通信                 4.82           8.94  18.60%      会员   2024/7/16  5.573   \n",
       "鼎信通讯                15.15          28.14   5.30%      会员   2024/4/16  5.323   \n",
       "梦百合                 13.32          24.74  10.80%      会员   2024/11/8  5.888   \n",
       "华源控股                 5.31           9.85  18.50%      会员  2024/11/27  5.940   \n",
       "万顺股份                 4.53           8.41  34.70%      会员   2024/7/20  5.584   \n",
       "小康股份                12.04          22.36   5.50%      会员   2023/11/6  4.879   \n",
       "旭升股份                 20.9          38.82   3.50%      会员  2024/11/22  5.926   \n",
       "三力士                  4.09           7.59  17.00%      会员    2024/6/7  5.466   \n",
       "蓝盾股份                 4.07           7.57   8.70%      会员   2024/8/13  5.649   \n",
       "吴江银行                    -           8.24  26.80%      会员    2024/8/1  5.616   \n",
       "国祯环保                  6.1          11.34  12.00%      会员  2023/11/24  4.929   \n",
       "安井食品                24.82           46.1   6.30%      会员   2024/7/12  5.562   \n",
       "横河模具                 6.48          12.04   8.10%      会员   2024/7/26  5.600   \n",
       "凯发电气                 5.71           10.6  17.60%      会员   2023/7/27  4.600   \n",
       "利欧股份                  1.2           2.24  14.60%      会员   2024/3/22  5.255   \n",
       "三一重工                 5.08           9.43   6.20%      会员    2022/1/4  3.041   \n",
       "常熟银行                    -           7.49  20.30%      会员   2024/1/19  5.082   \n",
       "科森科技                 6.26          11.63  18.40%      会员  2024/11/16  5.910   \n",
       "山鹰纸业                 2.34           4.34  16.00%      会员  2024/11/21  5.923   \n",
       "东音股份                    8          14.86  14.00%      会员    2024/8/2  5.619   \n",
       "长久物流                 8.39          15.59  11.40%      会员   2024/11/7  5.885   \n",
       "张家港行                    -           7.88  24.70%      会员  2024/11/12  5.899   \n",
       "洲明科技                 6.62          12.29   8.30%      会员   2024/11/7  5.885   \n",
       "圆通速递                 7.62          14.16  12.70%      会员  2024/11/19  5.918   \n",
       "江阴银行                    -           7.37  21.90%      会员   2024/1/26  5.101   \n",
       "东方财富                 7.95          14.77   7.20%      会员  2023/12/20  5.000   \n",
       "崇达技术                10.58          19.64   6.50%      会员  2023/12/15  4.986   \n",
       "康泰生物                21.86           40.6   1.00%      会员    2024/2/1  5.118   \n",
       "...                   ...            ...     ...     ...         ...    ...   \n",
       "金禾实业                16.32          30.32   6.90%      会员   2023/11/1  4.866   \n",
       "双环传动                 6.99          12.99  24.00%      会员  2023/12/25  5.014   \n",
       "太阳纸业                 6.12          11.38   8.00%      会员  2022/12/22  4.005   \n",
       "铁汉生态                 5.76           10.7  10.00%      会员  2023/12/18  4.995   \n",
       "千禾味业                18.09           33.6   7.00%      会员   2024/6/19  5.499   \n",
       "东方雨虹                15.84          29.42   8.70%      会员   2023/9/25  4.764   \n",
       "众兴菌业                 8.15          15.13  37.80%      会员  2023/12/13  4.981   \n",
       "众信旅游                  7.7           14.3  12.70%      会员   2023/12/1  4.948   \n",
       "久其软件                    9          16.72  14.90%      会员    2023/6/8  4.466   \n",
       "中化岩土                 5.62          10.44   7.60%      会员   2024/3/15  5.236   \n",
       "江南水务                 4.82           7.83   1.40%      会员   2022/3/18  3.241   \n",
       "林洋能源                 6.13          11.39  34.40%      会员  2023/10/27  4.852   \n",
       "道氏技术                17.42          32.34   7.40%      会员  2023/12/28  5.022   \n",
       "天康生物                 5.71           10.6  23.70%      会员  2023/12/22  5.005   \n",
       "大族激光                36.75          68.25   7.20%      会员    2024/2/6  5.132   \n",
       "赣锋锂业                29.81          55.35   3.10%      会员  2023/12/21  5.000   \n",
       "嘉澳环保                31.69          58.85  11.20%      会员   2023/11/9  4.888   \n",
       "格力地产                 4.86           9.02   5.20%      会员  2019/12/25  1.011   \n",
       "新时达                  8.28          15.38  25.90%      会员   2023/11/6  4.879   \n",
       "凤凰传媒                12.29          19.97  25.60%      会员  2021/10/31  2.863   \n",
       "航天信息                29.67          55.09   5.70%      会员   2021/6/12  2.477   \n",
       "上海建工                 4.54           8.42  18.40%      会员   2021/11/5  2.877   \n",
       "蓝思科技                11.26           20.9  17.40%      会员   2023/12/8  4.967   \n",
       "亚太股份                 7.24          13.44  31.20%      会员   2023/12/8  4.967   \n",
       "山东高速                 6.73          12.51  11.60%      会员   2022/4/24  3.342   \n",
       "模塑科技                  5.4          10.04  32.40%      会员    2023/6/2  4.449   \n",
       "澳洋顺昌                  6.5          12.06  12.90%      会员   2022/1/22  3.090   \n",
       "浙数文化                17.07          31.71  22.10%      会员   2022/8/17  3.658   \n",
       "洪涛股份                 6.99          12.97  32.00%      会员   2022/7/29  3.605   \n",
       "ST辉丰                  5.4          10.02  27.20%      会员   2022/4/21  3.334   \n",
       "\n",
       "            return shuishou_ret  amount operation  \n",
       "stock_name                                         \n",
       "广电网络         2.53%        2.07%      购买   8124.81  \n",
       "德尔股份         3.42%        2.83%      购买    552.09  \n",
       "盛路通信         2.74%        2.22%      购买   2756.46  \n",
       "鼎信通讯         0.82%        0.45%      购买  10791.86  \n",
       "梦百合          2.26%        1.77%      购买   5335.30  \n",
       "华源控股         4.00%        3.49%      购买   4121.92  \n",
       "万顺股份         2.92%        2.52%      购买    683.00  \n",
       "小康股份         2.62%        2.19%      购买    154.45  \n",
       "旭升股份         2.85%        2.24%      购买   1278.18  \n",
       "三力士          2.66%        2.28%      购买    297.13  \n",
       "蓝盾股份         3.78%        3.32%      购买   1407.90  \n",
       "吴江银行         1.83%        1.32%      购买   6274.18  \n",
       "国祯环保         0.53%        0.14%      购买      8.36  \n",
       "安井食品         1.09%        0.66%      购买   1367.18  \n",
       "横河模具         4.36%        3.79%      购买     67.37  \n",
       "凯发电气         3.79%        3.38%      购买    296.51  \n",
       "利欧股份         4.38%        3.85%      购买    120.80  \n",
       "三一重工        -3.31%       -3.90%      购买   2206.75  \n",
       "常熟银行        -0.29%       -0.65%      购买   7967.82  \n",
       "科森科技         3.80%        3.29%      购买    661.73  \n",
       "山鹰纸业         3.06%        2.49%      购买   2656.96  \n",
       "东音股份         3.74%        3.22%      购买     64.52  \n",
       "长久物流         3.52%        2.88%      购买    318.09  \n",
       "张家港行         2.29%        1.83%      购买   1629.14  \n",
       "洲明科技         2.74%        2.24%      购买   1051.26  \n",
       "圆通速递         2.24%        1.75%      购买   4640.12  \n",
       "江阴银行         2.10%        1.73%      购买   1465.77  \n",
       "东方财富        -1.64%       -2.02%      购买   8578.44  \n",
       "崇达技术         1.17%        0.76%      购买    100.93  \n",
       "康泰生物        -1.87%       -2.26%      购买    737.16  \n",
       "...            ...          ...     ...       ...  \n",
       "金禾实业         1.90%        1.50%      购买      5.05  \n",
       "双环传动         3.93%        3.49%      购买    172.47  \n",
       "太阳纸业         2.12%        1.71%      购买    116.58  \n",
       "铁汉生态         4.42%        4.01%      购买  15820.43  \n",
       "千禾味业         3.69%        3.23%      购买     83.57  \n",
       "东方雨虹         2.62%        2.20%      购买    408.48  \n",
       "众兴菌业         5.07%        4.62%      购买    545.26  \n",
       "众信旅游         3.56%        3.15%      购买      7.44  \n",
       "久其软件         4.64%        4.10%      购买    153.88  \n",
       "中化岩土         5.05%        4.56%      购买    136.46  \n",
       "江南水务         3.05%        2.32%      购买    330.99  \n",
       "林洋能源         3.33%        2.89%      购买    416.19  \n",
       "道氏技术         3.04%        2.56%      购买    779.73  \n",
       "天康生物         4.54%        4.02%      购买    115.34  \n",
       "大族激光         1.89%        1.56%      购买   1181.14  \n",
       "赣锋锂业         2.74%        2.36%      购买    293.35  \n",
       "嘉澳环保         4.99%        4.47%      购买     35.32  \n",
       "格力地产         3.87%        2.41%      购买    423.62  \n",
       "新时达          5.08%        4.63%      购买    414.90  \n",
       "凤凰传媒         4.05%        3.50%      购买     29.96  \n",
       "航天信息         1.41%        0.65%      购买    204.51  \n",
       "上海建工         3.21%        2.79%      购买    809.71  \n",
       "蓝思科技         4.21%        3.79%      购买    351.86  \n",
       "亚太股份         5.22%        4.71%      购买    469.78  \n",
       "山东高速         3.95%        3.20%      购买      0.00  \n",
       "模塑科技         6.49%        5.82%      购买    159.49  \n",
       "澳洋顺昌         4.66%        3.88%      购买    104.21  \n",
       "浙数文化         4.03%        3.69%      购买   1036.52  \n",
       "洪涛股份         6.84%        6.15%      购买    233.71  \n",
       "ST辉丰         9.30%        8.84%      购买    531.51  \n",
       "\n",
       "[113 rows x 23 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "column_name = [\"bond_code\",\"bond_name\",\"bond_price\",\"bond_x1\",\"stock_name\",\"stock_price\",\"stock_x1\",\"pb\",\"convert_price\",\\\n",
    "              \"convert_value\",\"premium\",\"bond_value\",\"band\",\"option_value\",\"shuishou_price\",\"qiangshu_price\",\"bond_x2\",\\\n",
    "              \"bond_x3\",\"expire\",\"year\",\"return\",\"shuishou_ret\",\"amount\",\"operation\"]\n",
    "kezhuanzhai_basic_info_dir = \"C:\\\\quanttime\\\\src\\\\convertbond\\\\tmp.csv\"\n",
    "bond_basic_info = pd.read_csv(kezhuanzhai_basic_info_dir,index_col=False,encoding=\"gbk\",names=column_name)\n",
    "bond_basic_info = bond_basic_info.set_index(\"stock_name\")\n",
    "bond_basic_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['000001.XSHE', 'PAYH', '1991/4/3', '2200/1/1', 'stock']"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stock_basic_info_dir = \"C:\\\\quanttime\\\\data\\\\basic_info\\\\all_stock_info.csv\"\n",
    "stock_info_basic = pd.read_csv(stock_basic_info_dir, index_col=[\"display_name\"],encoding=\"gbk\")\n",
    "stock_info_basic.loc['平安银行',[\"code\",\"name\",\"start_date\",\"end_date\",\"type\"]].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bond_code</th>\n",
       "      <th>bond_name</th>\n",
       "      <th>bond_price</th>\n",
       "      <th>bond_x1</th>\n",
       "      <th>stock_price</th>\n",
       "      <th>stock_x1</th>\n",
       "      <th>pb</th>\n",
       "      <th>convert_price</th>\n",
       "      <th>convert_value</th>\n",
       "      <th>premium</th>\n",
       "      <th>...</th>\n",
       "      <th>year</th>\n",
       "      <th>return</th>\n",
       "      <th>shuishou_ret</th>\n",
       "      <th>amount</th>\n",
       "      <th>operation</th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>start_date</th>\n",
       "      <th>end_date</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ST辉丰</th>\n",
       "      <td>128012</td>\n",
       "      <td>辉丰转债</td>\n",
       "      <td>79.761</td>\n",
       "      <td>-1.15%</td>\n",
       "      <td>2.06</td>\n",
       "      <td>-0.96%</td>\n",
       "      <td>0.89</td>\n",
       "      <td>7.71</td>\n",
       "      <td>26.59</td>\n",
       "      <td>199.98%</td>\n",
       "      <td>...</td>\n",
       "      <td>3.334</td>\n",
       "      <td>9.30%</td>\n",
       "      <td>8.84%</td>\n",
       "      <td>购买</td>\n",
       "      <td>531.51</td>\n",
       "      <td>002496.XSHE</td>\n",
       "      <td>HFGF</td>\n",
       "      <td>2010/11/9</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>万顺股份</th>\n",
       "      <td>123012</td>\n",
       "      <td>万顺转债</td>\n",
       "      <td>95.100</td>\n",
       "      <td>-1.59%</td>\n",
       "      <td>6.22</td>\n",
       "      <td>-2.66%</td>\n",
       "      <td>1.02</td>\n",
       "      <td>6.47</td>\n",
       "      <td>95.83</td>\n",
       "      <td>-0.76%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.584</td>\n",
       "      <td>2.92%</td>\n",
       "      <td>2.52%</td>\n",
       "      <td>购买</td>\n",
       "      <td>683.00</td>\n",
       "      <td>300057.XSHE</td>\n",
       "      <td>WSGF</td>\n",
       "      <td>2010/2/26</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>三一重工</th>\n",
       "      <td>110032</td>\n",
       "      <td>三一转债</td>\n",
       "      <td>121.700</td>\n",
       "      <td>-0.41%</td>\n",
       "      <td>8.46</td>\n",
       "      <td>-0.35%</td>\n",
       "      <td>2.64</td>\n",
       "      <td>7.25</td>\n",
       "      <td>116.55</td>\n",
       "      <td>4.42%</td>\n",
       "      <td>...</td>\n",
       "      <td>3.041</td>\n",
       "      <td>-3.31%</td>\n",
       "      <td>-3.90%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2206.75</td>\n",
       "      <td>600031.XSHG</td>\n",
       "      <td>SYZG</td>\n",
       "      <td>2003/7/3</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>三力士</th>\n",
       "      <td>128039</td>\n",
       "      <td>三力转债</td>\n",
       "      <td>96.066</td>\n",
       "      <td>-0.42%</td>\n",
       "      <td>5.52</td>\n",
       "      <td>-1.60%</td>\n",
       "      <td>1.90</td>\n",
       "      <td>5.840*</td>\n",
       "      <td>94.52</td>\n",
       "      <td>1.64%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.466</td>\n",
       "      <td>2.66%</td>\n",
       "      <td>2.28%</td>\n",
       "      <td>购买</td>\n",
       "      <td>297.13</td>\n",
       "      <td>002224.XSHE</td>\n",
       "      <td>SLS</td>\n",
       "      <td>2008/4/25</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海建工</th>\n",
       "      <td>132004</td>\n",
       "      <td>15国盛EB</td>\n",
       "      <td>96.760</td>\n",
       "      <td>-0.03%</td>\n",
       "      <td>3.05</td>\n",
       "      <td>-0.65%</td>\n",
       "      <td>0.95</td>\n",
       "      <td>6.48</td>\n",
       "      <td>47.07</td>\n",
       "      <td>105.85%</td>\n",
       "      <td>...</td>\n",
       "      <td>2.877</td>\n",
       "      <td>3.21%</td>\n",
       "      <td>2.79%</td>\n",
       "      <td>购买</td>\n",
       "      <td>809.71</td>\n",
       "      <td>600170.XSHG</td>\n",
       "      <td>SHJG</td>\n",
       "      <td>1998/6/23</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>上海电气</th>\n",
       "      <td>113008</td>\n",
       "      <td>电气转债</td>\n",
       "      <td>106.500</td>\n",
       "      <td>-0.26%</td>\n",
       "      <td>4.99</td>\n",
       "      <td>0.60%</td>\n",
       "      <td>1.29</td>\n",
       "      <td>5.190*</td>\n",
       "      <td>95.95</td>\n",
       "      <td>10.99%</td>\n",
       "      <td>...</td>\n",
       "      <td>2.121</td>\n",
       "      <td>1.39%</td>\n",
       "      <td>0.53%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2422.71</td>\n",
       "      <td>601727.XSHG</td>\n",
       "      <td>SHDQ</td>\n",
       "      <td>2008/12/5</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方财富</th>\n",
       "      <td>123006</td>\n",
       "      <td>东财转债</td>\n",
       "      <td>119.900</td>\n",
       "      <td>-1.32%</td>\n",
       "      <td>12.50</td>\n",
       "      <td>-1.65%</td>\n",
       "      <td>4.16</td>\n",
       "      <td>11.36</td>\n",
       "      <td>110.12</td>\n",
       "      <td>8.88%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.000</td>\n",
       "      <td>-1.64%</td>\n",
       "      <td>-2.02%</td>\n",
       "      <td>购买</td>\n",
       "      <td>8578.44</td>\n",
       "      <td>300059.XSHE</td>\n",
       "      <td>DFCF</td>\n",
       "      <td>2010/3/19</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东方雨虹</th>\n",
       "      <td>128016</td>\n",
       "      <td>雨虹转债</td>\n",
       "      <td>97.727</td>\n",
       "      <td>-0.93%</td>\n",
       "      <td>14.23</td>\n",
       "      <td>-2.80%</td>\n",
       "      <td>2.73</td>\n",
       "      <td>22.63</td>\n",
       "      <td>62.84</td>\n",
       "      <td>55.52%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.764</td>\n",
       "      <td>2.62%</td>\n",
       "      <td>2.20%</td>\n",
       "      <td>购买</td>\n",
       "      <td>408.48</td>\n",
       "      <td>002271.XSHE</td>\n",
       "      <td>DFYH</td>\n",
       "      <td>2008/9/10</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东音股份</th>\n",
       "      <td>128043</td>\n",
       "      <td>东音转债</td>\n",
       "      <td>94.339</td>\n",
       "      <td>-1.22%</td>\n",
       "      <td>10.03</td>\n",
       "      <td>-0.50%</td>\n",
       "      <td>2.29</td>\n",
       "      <td>11.430*</td>\n",
       "      <td>87.75</td>\n",
       "      <td>7.51%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.619</td>\n",
       "      <td>3.74%</td>\n",
       "      <td>3.22%</td>\n",
       "      <td>购买</td>\n",
       "      <td>64.52</td>\n",
       "      <td>002793.XSHE</td>\n",
       "      <td>DYGF</td>\n",
       "      <td>2016/4/15</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中化岩土</th>\n",
       "      <td>128037</td>\n",
       "      <td>岩土转债</td>\n",
       "      <td>87.830</td>\n",
       "      <td>-0.64%</td>\n",
       "      <td>4.36</td>\n",
       "      <td>-1.58%</td>\n",
       "      <td>2.10</td>\n",
       "      <td>8.03</td>\n",
       "      <td>54.30</td>\n",
       "      <td>61.76%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.236</td>\n",
       "      <td>5.05%</td>\n",
       "      <td>4.56%</td>\n",
       "      <td>购买</td>\n",
       "      <td>136.46</td>\n",
       "      <td>002542.XSHE</td>\n",
       "      <td>ZHYT</td>\n",
       "      <td>2011/1/28</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国化学</th>\n",
       "      <td>132014</td>\n",
       "      <td>18中化EBQ</td>\n",
       "      <td>99.000</td>\n",
       "      <td>-1.00%</td>\n",
       "      <td>5.55</td>\n",
       "      <td>-0.72%</td>\n",
       "      <td>0.93</td>\n",
       "      <td>7.66</td>\n",
       "      <td>72.45</td>\n",
       "      <td>37.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.342</td>\n",
       "      <td>2.27%</td>\n",
       "      <td>1.84%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1125.84</td>\n",
       "      <td>601117.XSHG</td>\n",
       "      <td>ZGHX</td>\n",
       "      <td>2010/1/7</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国太保</th>\n",
       "      <td>132005</td>\n",
       "      <td>15国资EB</td>\n",
       "      <td>107.510</td>\n",
       "      <td>-0.45%</td>\n",
       "      <td>29.05</td>\n",
       "      <td>-1.99%</td>\n",
       "      <td>1.84</td>\n",
       "      <td>36.65</td>\n",
       "      <td>79.26</td>\n",
       "      <td>35.72%</td>\n",
       "      <td>...</td>\n",
       "      <td>1.967</td>\n",
       "      <td>1.57%</td>\n",
       "      <td>0.54%</td>\n",
       "      <td>购买</td>\n",
       "      <td>35.06</td>\n",
       "      <td>601601.XSHG</td>\n",
       "      <td>ZGTB</td>\n",
       "      <td>2007/12/25</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中科曙光</th>\n",
       "      <td>113517</td>\n",
       "      <td>曙光转债</td>\n",
       "      <td>104.600</td>\n",
       "      <td>-0.61%</td>\n",
       "      <td>38.84</td>\n",
       "      <td>-0.36%</td>\n",
       "      <td>6.94</td>\n",
       "      <td>51.28</td>\n",
       "      <td>75.74</td>\n",
       "      <td>38.10%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.630</td>\n",
       "      <td>1.46%</td>\n",
       "      <td>1.02%</td>\n",
       "      <td>购买</td>\n",
       "      <td>939.31</td>\n",
       "      <td>603019.XSHG</td>\n",
       "      <td>ZKSG</td>\n",
       "      <td>2014/11/6</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航光电</th>\n",
       "      <td>128047</td>\n",
       "      <td>光电转债</td>\n",
       "      <td>106.300</td>\n",
       "      <td>-1.16%</td>\n",
       "      <td>32.30</td>\n",
       "      <td>-5.69%</td>\n",
       "      <td>4.63</td>\n",
       "      <td>40.26</td>\n",
       "      <td>80.10</td>\n",
       "      <td>32.70%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.879</td>\n",
       "      <td>0.59%</td>\n",
       "      <td>0.27%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2644.24</td>\n",
       "      <td>002179.XSHE</td>\n",
       "      <td>ZHGD</td>\n",
       "      <td>2007/11/1</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航机电</th>\n",
       "      <td>128045</td>\n",
       "      <td>机电转债</td>\n",
       "      <td>107.500</td>\n",
       "      <td>-1.29%</td>\n",
       "      <td>6.53</td>\n",
       "      <td>-5.09%</td>\n",
       "      <td>2.62</td>\n",
       "      <td>7.66</td>\n",
       "      <td>85.25</td>\n",
       "      <td>26.10%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.688</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>0.08%</td>\n",
       "      <td>购买</td>\n",
       "      <td>537.05</td>\n",
       "      <td>002013.XSHE</td>\n",
       "      <td>ZHJD</td>\n",
       "      <td>2004/7/5</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中航电子</th>\n",
       "      <td>110042</td>\n",
       "      <td>航电转债</td>\n",
       "      <td>109.210</td>\n",
       "      <td>-2.15%</td>\n",
       "      <td>13.67</td>\n",
       "      <td>-2.15%</td>\n",
       "      <td>3.28</td>\n",
       "      <td>14.23</td>\n",
       "      <td>95.99</td>\n",
       "      <td>13.77%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.011</td>\n",
       "      <td>0.15%</td>\n",
       "      <td>-0.23%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1959.65</td>\n",
       "      <td>600372.XSHG</td>\n",
       "      <td>ZHDZ</td>\n",
       "      <td>2001/7/6</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>久其软件</th>\n",
       "      <td>128015</td>\n",
       "      <td>久其转债</td>\n",
       "      <td>92.051</td>\n",
       "      <td>-0.70%</td>\n",
       "      <td>7.38</td>\n",
       "      <td>0.68%</td>\n",
       "      <td>2.47</td>\n",
       "      <td>12.86</td>\n",
       "      <td>57.31</td>\n",
       "      <td>60.62%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.466</td>\n",
       "      <td>4.64%</td>\n",
       "      <td>4.10%</td>\n",
       "      <td>购买</td>\n",
       "      <td>153.88</td>\n",
       "      <td>002279.XSHE</td>\n",
       "      <td>JQRJ</td>\n",
       "      <td>2009/8/11</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>久立特材</th>\n",
       "      <td>128019</td>\n",
       "      <td>久立转2</td>\n",
       "      <td>94.600</td>\n",
       "      <td>-1.05%</td>\n",
       "      <td>6.18</td>\n",
       "      <td>-1.75%</td>\n",
       "      <td>1.74</td>\n",
       "      <td>8.22</td>\n",
       "      <td>75.18</td>\n",
       "      <td>25.83%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.885</td>\n",
       "      <td>3.25%</td>\n",
       "      <td>2.84%</td>\n",
       "      <td>购买</td>\n",
       "      <td>371.93</td>\n",
       "      <td>002318.XSHE</td>\n",
       "      <td>JLTC</td>\n",
       "      <td>2009/12/11</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>九州通</th>\n",
       "      <td>110034</td>\n",
       "      <td>九州转债</td>\n",
       "      <td>102.300</td>\n",
       "      <td>-0.45%</td>\n",
       "      <td>14.70</td>\n",
       "      <td>-1.41%</td>\n",
       "      <td>1.54</td>\n",
       "      <td>18.42</td>\n",
       "      <td>79.91</td>\n",
       "      <td>28.01%</td>\n",
       "      <td>...</td>\n",
       "      <td>3.071</td>\n",
       "      <td>2.73%</td>\n",
       "      <td>2.05%</td>\n",
       "      <td>购买</td>\n",
       "      <td>187.41</td>\n",
       "      <td>600998.XSHG</td>\n",
       "      <td>JZT</td>\n",
       "      <td>2010/11/2</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>亚太股份</th>\n",
       "      <td>128023</td>\n",
       "      <td>亚太转债</td>\n",
       "      <td>88.020</td>\n",
       "      <td>-0.22%</td>\n",
       "      <td>4.35</td>\n",
       "      <td>-2.25%</td>\n",
       "      <td>1.14</td>\n",
       "      <td>10.34</td>\n",
       "      <td>41.88</td>\n",
       "      <td>110.19%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.967</td>\n",
       "      <td>5.22%</td>\n",
       "      <td>4.71%</td>\n",
       "      <td>购买</td>\n",
       "      <td>469.78</td>\n",
       "      <td>002284.XSHE</td>\n",
       "      <td>YTGF</td>\n",
       "      <td>2009/8/28</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>众信旅游</th>\n",
       "      <td>128022</td>\n",
       "      <td>众信转债</td>\n",
       "      <td>93.061</td>\n",
       "      <td>-0.48%</td>\n",
       "      <td>6.45</td>\n",
       "      <td>-2.27%</td>\n",
       "      <td>2.28</td>\n",
       "      <td>11</td>\n",
       "      <td>58.64</td>\n",
       "      <td>58.71%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.948</td>\n",
       "      <td>3.56%</td>\n",
       "      <td>3.15%</td>\n",
       "      <td>购买</td>\n",
       "      <td>7.44</td>\n",
       "      <td>002707.XSHE</td>\n",
       "      <td>ZXLY</td>\n",
       "      <td>2014/1/23</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>众兴菌业</th>\n",
       "      <td>128026</td>\n",
       "      <td>众兴转债</td>\n",
       "      <td>87.115</td>\n",
       "      <td>-0.71%</td>\n",
       "      <td>6.51</td>\n",
       "      <td>-1.06%</td>\n",
       "      <td>0.89</td>\n",
       "      <td>11.64</td>\n",
       "      <td>55.93</td>\n",
       "      <td>55.76%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.981</td>\n",
       "      <td>5.07%</td>\n",
       "      <td>4.62%</td>\n",
       "      <td>购买</td>\n",
       "      <td>545.26</td>\n",
       "      <td>002772.XSHE</td>\n",
       "      <td>ZXJY</td>\n",
       "      <td>2015/6/26</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>兄弟科技</th>\n",
       "      <td>128021</td>\n",
       "      <td>兄弟转债</td>\n",
       "      <td>96.179</td>\n",
       "      <td>-0.74%</td>\n",
       "      <td>4.38</td>\n",
       "      <td>-3.10%</td>\n",
       "      <td>1.70</td>\n",
       "      <td>5.350*</td>\n",
       "      <td>81.87</td>\n",
       "      <td>17.48%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.940</td>\n",
       "      <td>2.86%</td>\n",
       "      <td>2.46%</td>\n",
       "      <td>购买</td>\n",
       "      <td>326.11</td>\n",
       "      <td>002562.XSHE</td>\n",
       "      <td>XDKJ</td>\n",
       "      <td>2011/3/10</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>光大银行</th>\n",
       "      <td>113011</td>\n",
       "      <td>光大转债</td>\n",
       "      <td>103.900</td>\n",
       "      <td>-0.55%</td>\n",
       "      <td>3.63</td>\n",
       "      <td>-1.89%</td>\n",
       "      <td>0.61</td>\n",
       "      <td>4.13</td>\n",
       "      <td>88.14</td>\n",
       "      <td>17.89%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.238</td>\n",
       "      <td>1.34%</td>\n",
       "      <td>0.90%</td>\n",
       "      <td>购买</td>\n",
       "      <td>15270.09</td>\n",
       "      <td>601818.XSHG</td>\n",
       "      <td>GDYH</td>\n",
       "      <td>2010/8/18</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>内蒙华电</th>\n",
       "      <td>110041</td>\n",
       "      <td>蒙电转债</td>\n",
       "      <td>99.200</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>2.19</td>\n",
       "      <td>1.86%</td>\n",
       "      <td>1.16</td>\n",
       "      <td>2.92</td>\n",
       "      <td>74.66</td>\n",
       "      <td>32.87%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.000</td>\n",
       "      <td>2.30%</td>\n",
       "      <td>1.88%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1740.20</td>\n",
       "      <td>600863.XSHG</td>\n",
       "      <td>NMHD</td>\n",
       "      <td>1994/5/20</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>再升科技</th>\n",
       "      <td>113510</td>\n",
       "      <td>再升转债</td>\n",
       "      <td>93.180</td>\n",
       "      <td>-0.52%</td>\n",
       "      <td>7.61</td>\n",
       "      <td>0.13%</td>\n",
       "      <td>3.21</td>\n",
       "      <td>11.32</td>\n",
       "      <td>67.31</td>\n",
       "      <td>38.42%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.496</td>\n",
       "      <td>3.70%</td>\n",
       "      <td>3.23%</td>\n",
       "      <td>购买</td>\n",
       "      <td>42.50</td>\n",
       "      <td>603601.XSHG</td>\n",
       "      <td>ZSKJ</td>\n",
       "      <td>2015/1/22</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>凤凰传媒</th>\n",
       "      <td>132007</td>\n",
       "      <td>16凤凰EBQ</td>\n",
       "      <td>96.350</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>7.68</td>\n",
       "      <td>0.79%</td>\n",
       "      <td>1.49</td>\n",
       "      <td>15.36</td>\n",
       "      <td>50.07</td>\n",
       "      <td>92.73%</td>\n",
       "      <td>...</td>\n",
       "      <td>2.863</td>\n",
       "      <td>4.05%</td>\n",
       "      <td>3.50%</td>\n",
       "      <td>购买</td>\n",
       "      <td>29.96</td>\n",
       "      <td>601928.XSHG</td>\n",
       "      <td>FHCM</td>\n",
       "      <td>2011/11/30</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>凯中精密</th>\n",
       "      <td>128042</td>\n",
       "      <td>凯中转债</td>\n",
       "      <td>95.300</td>\n",
       "      <td>-0.31%</td>\n",
       "      <td>10.25</td>\n",
       "      <td>0.20%</td>\n",
       "      <td>2.28</td>\n",
       "      <td>13.25</td>\n",
       "      <td>77.36</td>\n",
       "      <td>23.19%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.611</td>\n",
       "      <td>3.85%</td>\n",
       "      <td>3.27%</td>\n",
       "      <td>购买</td>\n",
       "      <td>27.55</td>\n",
       "      <td>002823.XSHE</td>\n",
       "      <td>KZJM</td>\n",
       "      <td>2016/11/24</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>凯发电气</th>\n",
       "      <td>123014</td>\n",
       "      <td>凯发转债</td>\n",
       "      <td>92.508</td>\n",
       "      <td>-0.81%</td>\n",
       "      <td>7.21</td>\n",
       "      <td>-1.90%</td>\n",
       "      <td>1.85</td>\n",
       "      <td>8.15</td>\n",
       "      <td>88.83</td>\n",
       "      <td>4.14%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.600</td>\n",
       "      <td>3.79%</td>\n",
       "      <td>3.38%</td>\n",
       "      <td>购买</td>\n",
       "      <td>296.51</td>\n",
       "      <td>300407.XSHE</td>\n",
       "      <td>KFDQ</td>\n",
       "      <td>2014/12/3</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>利尔化学</th>\n",
       "      <td>128046</td>\n",
       "      <td>利尔转债</td>\n",
       "      <td>100.000</td>\n",
       "      <td>-0.20%</td>\n",
       "      <td>13.84</td>\n",
       "      <td>0.44%</td>\n",
       "      <td>2.59</td>\n",
       "      <td>18.82</td>\n",
       "      <td>73.49</td>\n",
       "      <td>36.08%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.827</td>\n",
       "      <td>2.21%</td>\n",
       "      <td>1.78%</td>\n",
       "      <td>购买</td>\n",
       "      <td>19.72</td>\n",
       "      <td>002258.XSHE</td>\n",
       "      <td>LEHX</td>\n",
       "      <td>2008/7/8</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>洲明科技</th>\n",
       "      <td>123016</td>\n",
       "      <td>洲明转债</td>\n",
       "      <td>99.120</td>\n",
       "      <td>-0.58%</td>\n",
       "      <td>8.63</td>\n",
       "      <td>-1.03%</td>\n",
       "      <td>3.13</td>\n",
       "      <td>9.45</td>\n",
       "      <td>91.43</td>\n",
       "      <td>8.41%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.885</td>\n",
       "      <td>2.74%</td>\n",
       "      <td>2.24%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1051.26</td>\n",
       "      <td>300232.XSHE</td>\n",
       "      <td>ZMKJ</td>\n",
       "      <td>2011/6/22</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>济川药业</th>\n",
       "      <td>110038</td>\n",
       "      <td>济川转债</td>\n",
       "      <td>108.300</td>\n",
       "      <td>-0.10%</td>\n",
       "      <td>33.72</td>\n",
       "      <td>-0.77%</td>\n",
       "      <td>5.41</td>\n",
       "      <td>40.04</td>\n",
       "      <td>84.24</td>\n",
       "      <td>28.56%</td>\n",
       "      <td>...</td>\n",
       "      <td>3.896</td>\n",
       "      <td>0.12%</td>\n",
       "      <td>-0.30%</td>\n",
       "      <td>购买</td>\n",
       "      <td>212.12</td>\n",
       "      <td>600566.XSHG</td>\n",
       "      <td>JCYY</td>\n",
       "      <td>2001/8/22</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>浙数文化</th>\n",
       "      <td>132011</td>\n",
       "      <td>17浙报EBQ</td>\n",
       "      <td>91.610</td>\n",
       "      <td>-0.21%</td>\n",
       "      <td>8.33</td>\n",
       "      <td>0.60%</td>\n",
       "      <td>1.37</td>\n",
       "      <td>24.39</td>\n",
       "      <td>34.11</td>\n",
       "      <td>169.57%</td>\n",
       "      <td>...</td>\n",
       "      <td>3.658</td>\n",
       "      <td>4.03%</td>\n",
       "      <td>3.69%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1036.52</td>\n",
       "      <td>600633.XSHG</td>\n",
       "      <td>ZBCM</td>\n",
       "      <td>1993/3/4</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海印股份</th>\n",
       "      <td>127003</td>\n",
       "      <td>海印转债</td>\n",
       "      <td>90.869</td>\n",
       "      <td>-0.02%</td>\n",
       "      <td>2.49</td>\n",
       "      <td>-0.80%</td>\n",
       "      <td>1.62</td>\n",
       "      <td>3.500*</td>\n",
       "      <td>71.14</td>\n",
       "      <td>27.73%</td>\n",
       "      <td>...</td>\n",
       "      <td>3.466</td>\n",
       "      <td>7.00%</td>\n",
       "      <td>6.17%</td>\n",
       "      <td>购买</td>\n",
       "      <td>636.75</td>\n",
       "      <td>000861.XSHE</td>\n",
       "      <td>HYGF</td>\n",
       "      <td>1998/10/28</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海澜之家</th>\n",
       "      <td>110045</td>\n",
       "      <td>海澜转债</td>\n",
       "      <td>97.460</td>\n",
       "      <td>-0.71%</td>\n",
       "      <td>8.53</td>\n",
       "      <td>-0.23%</td>\n",
       "      <td>3.10</td>\n",
       "      <td>12.4</td>\n",
       "      <td>68.79</td>\n",
       "      <td>41.68%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.564</td>\n",
       "      <td>2.55%</td>\n",
       "      <td>2.15%</td>\n",
       "      <td>购买</td>\n",
       "      <td>454.39</td>\n",
       "      <td>600398.XSHG</td>\n",
       "      <td>HLZJ</td>\n",
       "      <td>2000/12/28</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>湖北广电</th>\n",
       "      <td>127007</td>\n",
       "      <td>湖广转债</td>\n",
       "      <td>95.201</td>\n",
       "      <td>-0.31%</td>\n",
       "      <td>7.24</td>\n",
       "      <td>0.70%</td>\n",
       "      <td>0.72</td>\n",
       "      <td>10.16</td>\n",
       "      <td>71.26</td>\n",
       "      <td>33.60%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.523</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>2.85%</td>\n",
       "      <td>购买</td>\n",
       "      <td>728.84</td>\n",
       "      <td>000665.XSHE</td>\n",
       "      <td>HBGD</td>\n",
       "      <td>1996/12/10</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>澳洋顺昌</th>\n",
       "      <td>128010</td>\n",
       "      <td>顺昌转债</td>\n",
       "      <td>97.801</td>\n",
       "      <td>-0.20%</td>\n",
       "      <td>4.01</td>\n",
       "      <td>-2.43%</td>\n",
       "      <td>1.48</td>\n",
       "      <td>9.28</td>\n",
       "      <td>43.21</td>\n",
       "      <td>126.33%</td>\n",
       "      <td>...</td>\n",
       "      <td>3.090</td>\n",
       "      <td>4.66%</td>\n",
       "      <td>3.88%</td>\n",
       "      <td>购买</td>\n",
       "      <td>104.21</td>\n",
       "      <td>002245.XSHE</td>\n",
       "      <td>AYSC</td>\n",
       "      <td>2008/6/5</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>特一药业</th>\n",
       "      <td>128025</td>\n",
       "      <td>特一转债</td>\n",
       "      <td>93.498</td>\n",
       "      <td>-0.24%</td>\n",
       "      <td>13.03</td>\n",
       "      <td>-1.29%</td>\n",
       "      <td>2.45</td>\n",
       "      <td>16.100*</td>\n",
       "      <td>80.93</td>\n",
       "      <td>15.53%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.962</td>\n",
       "      <td>3.45%</td>\n",
       "      <td>3.04%</td>\n",
       "      <td>购买</td>\n",
       "      <td>85.78</td>\n",
       "      <td>002728.XSHE</td>\n",
       "      <td>TYYY</td>\n",
       "      <td>2014/7/31</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>玲珑轮胎</th>\n",
       "      <td>113019</td>\n",
       "      <td>玲珑转债</td>\n",
       "      <td>100.000</td>\n",
       "      <td>-0.15%</td>\n",
       "      <td>13.91</td>\n",
       "      <td>-1.14%</td>\n",
       "      <td>1.72</td>\n",
       "      <td>18.84</td>\n",
       "      <td>73.62</td>\n",
       "      <td>35.83%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.195</td>\n",
       "      <td>3.06%</td>\n",
       "      <td>2.47%</td>\n",
       "      <td>购买</td>\n",
       "      <td>398.04</td>\n",
       "      <td>601966.XSHG</td>\n",
       "      <td>LLLT</td>\n",
       "      <td>2016/7/6</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>生益科技</th>\n",
       "      <td>110040</td>\n",
       "      <td>生益转债</td>\n",
       "      <td>102.500</td>\n",
       "      <td>-0.48%</td>\n",
       "      <td>9.50</td>\n",
       "      <td>0.00%</td>\n",
       "      <td>3.24</td>\n",
       "      <td>11.62</td>\n",
       "      <td>81.84</td>\n",
       "      <td>25.24%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.926</td>\n",
       "      <td>1.53%</td>\n",
       "      <td>1.13%</td>\n",
       "      <td>购买</td>\n",
       "      <td>463.25</td>\n",
       "      <td>600183.XSHG</td>\n",
       "      <td>SYKJ</td>\n",
       "      <td>1998/10/28</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>盛路通信</th>\n",
       "      <td>128041</td>\n",
       "      <td>盛路转债</td>\n",
       "      <td>99.670</td>\n",
       "      <td>-0.16%</td>\n",
       "      <td>7.06</td>\n",
       "      <td>-0.14%</td>\n",
       "      <td>1.90</td>\n",
       "      <td>6.88</td>\n",
       "      <td>102.47</td>\n",
       "      <td>-2.73%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.573</td>\n",
       "      <td>2.74%</td>\n",
       "      <td>2.22%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2756.46</td>\n",
       "      <td>002446.XSHE</td>\n",
       "      <td>SLTX</td>\n",
       "      <td>2010/7/13</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>科森科技</th>\n",
       "      <td>113521</td>\n",
       "      <td>科森转债</td>\n",
       "      <td>93.250</td>\n",
       "      <td>-0.14%</td>\n",
       "      <td>7.97</td>\n",
       "      <td>0.76%</td>\n",
       "      <td>1.89</td>\n",
       "      <td>8.95</td>\n",
       "      <td>89.05</td>\n",
       "      <td>4.72%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.910</td>\n",
       "      <td>3.80%</td>\n",
       "      <td>3.29%</td>\n",
       "      <td>购买</td>\n",
       "      <td>661.73</td>\n",
       "      <td>603626.XSHG</td>\n",
       "      <td>KSKJ</td>\n",
       "      <td>2017/2/9</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>航天信息</th>\n",
       "      <td>110031</td>\n",
       "      <td>航信转债</td>\n",
       "      <td>106.310</td>\n",
       "      <td>-0.18%</td>\n",
       "      <td>22.75</td>\n",
       "      <td>-0.13%</td>\n",
       "      <td>4.09</td>\n",
       "      <td>42.38</td>\n",
       "      <td>53.66</td>\n",
       "      <td>98.13%</td>\n",
       "      <td>...</td>\n",
       "      <td>2.477</td>\n",
       "      <td>1.41%</td>\n",
       "      <td>0.65%</td>\n",
       "      <td>购买</td>\n",
       "      <td>204.51</td>\n",
       "      <td>600271.XSHG</td>\n",
       "      <td>HTXX</td>\n",
       "      <td>2003/7/11</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>艾华集团</th>\n",
       "      <td>113504</td>\n",
       "      <td>艾华转债</td>\n",
       "      <td>106.600</td>\n",
       "      <td>-1.75%</td>\n",
       "      <td>20.50</td>\n",
       "      <td>-0.49%</td>\n",
       "      <td>4.03</td>\n",
       "      <td>21.730*</td>\n",
       "      <td>94.34</td>\n",
       "      <td>13.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.197</td>\n",
       "      <td>0.81%</td>\n",
       "      <td>0.41%</td>\n",
       "      <td>购买</td>\n",
       "      <td>237.21</td>\n",
       "      <td>603989.XSHG</td>\n",
       "      <td>AHJT</td>\n",
       "      <td>2015/5/15</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蓝思科技</th>\n",
       "      <td>123003</td>\n",
       "      <td>蓝思转债</td>\n",
       "      <td>90.200</td>\n",
       "      <td>-0.24%</td>\n",
       "      <td>7.00</td>\n",
       "      <td>-0.43%</td>\n",
       "      <td>1.59</td>\n",
       "      <td>16.080*</td>\n",
       "      <td>43.53</td>\n",
       "      <td>107.20%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.967</td>\n",
       "      <td>4.21%</td>\n",
       "      <td>3.79%</td>\n",
       "      <td>购买</td>\n",
       "      <td>351.86</td>\n",
       "      <td>300433.XSHE</td>\n",
       "      <td>LSKJ</td>\n",
       "      <td>2015/3/18</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蓝盾股份</th>\n",
       "      <td>123015</td>\n",
       "      <td>蓝盾转债</td>\n",
       "      <td>92.280</td>\n",
       "      <td>-0.02%</td>\n",
       "      <td>5.25</td>\n",
       "      <td>0.77%</td>\n",
       "      <td>1.44</td>\n",
       "      <td>5.820*</td>\n",
       "      <td>90.03</td>\n",
       "      <td>2.49%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.649</td>\n",
       "      <td>3.78%</td>\n",
       "      <td>3.32%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1407.90</td>\n",
       "      <td>300297.XSHE</td>\n",
       "      <td>LDGF</td>\n",
       "      <td>2012/3/15</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蓝色光标</th>\n",
       "      <td>123001</td>\n",
       "      <td>蓝标转债</td>\n",
       "      <td>95.000</td>\n",
       "      <td>0.16%</td>\n",
       "      <td>4.54</td>\n",
       "      <td>1.57%</td>\n",
       "      <td>1.57</td>\n",
       "      <td>5.290**</td>\n",
       "      <td>85.63</td>\n",
       "      <td>10.94%</td>\n",
       "      <td>...</td>\n",
       "      <td>2.995</td>\n",
       "      <td>5.51%</td>\n",
       "      <td>4.77%</td>\n",
       "      <td>购买</td>\n",
       "      <td>2105.18</td>\n",
       "      <td>300058.XSHE</td>\n",
       "      <td>LSGB</td>\n",
       "      <td>2010/2/26</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>赣锋锂业</th>\n",
       "      <td>128028</td>\n",
       "      <td>赣锋转债</td>\n",
       "      <td>96.100</td>\n",
       "      <td>-1.13%</td>\n",
       "      <td>23.09</td>\n",
       "      <td>-4.55%</td>\n",
       "      <td>6.17</td>\n",
       "      <td>42.58</td>\n",
       "      <td>54.20</td>\n",
       "      <td>77.29%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.000</td>\n",
       "      <td>2.74%</td>\n",
       "      <td>2.36%</td>\n",
       "      <td>购买</td>\n",
       "      <td>293.35</td>\n",
       "      <td>002460.XSHE</td>\n",
       "      <td>GFLY</td>\n",
       "      <td>2010/8/10</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>道氏技术</th>\n",
       "      <td>123007</td>\n",
       "      <td>道氏转债</td>\n",
       "      <td>97.150</td>\n",
       "      <td>-1.26%</td>\n",
       "      <td>14.37</td>\n",
       "      <td>-3.23%</td>\n",
       "      <td>3.99</td>\n",
       "      <td>24.88</td>\n",
       "      <td>57.68</td>\n",
       "      <td>68.44%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.022</td>\n",
       "      <td>3.04%</td>\n",
       "      <td>2.56%</td>\n",
       "      <td>购买</td>\n",
       "      <td>779.73</td>\n",
       "      <td>300409.XSHE</td>\n",
       "      <td>DSJS</td>\n",
       "      <td>2014/12/3</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>金新农</th>\n",
       "      <td>128036</td>\n",
       "      <td>金农转债</td>\n",
       "      <td>87.340</td>\n",
       "      <td>-0.98%</td>\n",
       "      <td>6.79</td>\n",
       "      <td>-2.44%</td>\n",
       "      <td>1.60</td>\n",
       "      <td>9.62</td>\n",
       "      <td>70.58</td>\n",
       "      <td>23.74%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.219</td>\n",
       "      <td>4.87%</td>\n",
       "      <td>4.43%</td>\n",
       "      <td>购买</td>\n",
       "      <td>273.35</td>\n",
       "      <td>002548.XSHE</td>\n",
       "      <td>JXN</td>\n",
       "      <td>2011/2/18</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>金禾实业</th>\n",
       "      <td>128017</td>\n",
       "      <td>金禾转债</td>\n",
       "      <td>100.801</td>\n",
       "      <td>-0.20%</td>\n",
       "      <td>15.67</td>\n",
       "      <td>-0.51%</td>\n",
       "      <td>2.33</td>\n",
       "      <td>23.32</td>\n",
       "      <td>67.20</td>\n",
       "      <td>50.01%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.866</td>\n",
       "      <td>1.90%</td>\n",
       "      <td>1.50%</td>\n",
       "      <td>购买</td>\n",
       "      <td>5.05</td>\n",
       "      <td>002597.XSHE</td>\n",
       "      <td>JHSY</td>\n",
       "      <td>2011/7/7</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>铁汉生态</th>\n",
       "      <td>123004</td>\n",
       "      <td>铁汉转债</td>\n",
       "      <td>89.186</td>\n",
       "      <td>-2.09%</td>\n",
       "      <td>4.83</td>\n",
       "      <td>-10.06%</td>\n",
       "      <td>1.71</td>\n",
       "      <td>8.23</td>\n",
       "      <td>58.69</td>\n",
       "      <td>51.97%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.995</td>\n",
       "      <td>4.42%</td>\n",
       "      <td>4.01%</td>\n",
       "      <td>购买</td>\n",
       "      <td>15820.43</td>\n",
       "      <td>300197.XSHE</td>\n",
       "      <td>THST</td>\n",
       "      <td>2011/3/29</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长久物流</th>\n",
       "      <td>113519</td>\n",
       "      <td>长久转债</td>\n",
       "      <td>98.800</td>\n",
       "      <td>0.24%</td>\n",
       "      <td>10.98</td>\n",
       "      <td>-2.23%</td>\n",
       "      <td>2.74</td>\n",
       "      <td>11.99</td>\n",
       "      <td>91.58</td>\n",
       "      <td>7.89%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.885</td>\n",
       "      <td>3.52%</td>\n",
       "      <td>2.88%</td>\n",
       "      <td>购买</td>\n",
       "      <td>318.09</td>\n",
       "      <td>603569.XSHG</td>\n",
       "      <td>ZJWL</td>\n",
       "      <td>2016/8/10</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>长江证券</th>\n",
       "      <td>127005</td>\n",
       "      <td>长证转债</td>\n",
       "      <td>99.000</td>\n",
       "      <td>-0.40%</td>\n",
       "      <td>5.35</td>\n",
       "      <td>-1.11%</td>\n",
       "      <td>1.09</td>\n",
       "      <td>7.45</td>\n",
       "      <td>71.81</td>\n",
       "      <td>37.86%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.227</td>\n",
       "      <td>2.06%</td>\n",
       "      <td>1.69%</td>\n",
       "      <td>购买</td>\n",
       "      <td>407.87</td>\n",
       "      <td>000783.XSHE</td>\n",
       "      <td>CJZQ</td>\n",
       "      <td>1997/7/31</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>隆基股份</th>\n",
       "      <td>113015</td>\n",
       "      <td>隆基转债</td>\n",
       "      <td>101.430</td>\n",
       "      <td>-0.07%</td>\n",
       "      <td>17.79</td>\n",
       "      <td>0.45%</td>\n",
       "      <td>3.19</td>\n",
       "      <td>22.98</td>\n",
       "      <td>77.42</td>\n",
       "      <td>31.02%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.866</td>\n",
       "      <td>1.77%</td>\n",
       "      <td>1.36%</td>\n",
       "      <td>购买</td>\n",
       "      <td>1092.86</td>\n",
       "      <td>601012.XSHG</td>\n",
       "      <td>LJGF</td>\n",
       "      <td>2012/4/11</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>雪迪龙</th>\n",
       "      <td>128033</td>\n",
       "      <td>迪龙转债</td>\n",
       "      <td>94.950</td>\n",
       "      <td>-0.47%</td>\n",
       "      <td>7.46</td>\n",
       "      <td>0.13%</td>\n",
       "      <td>2.15</td>\n",
       "      <td>9.030*</td>\n",
       "      <td>82.61</td>\n",
       "      <td>14.93%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.019</td>\n",
       "      <td>3.15%</td>\n",
       "      <td>2.73%</td>\n",
       "      <td>购买</td>\n",
       "      <td>61.01</td>\n",
       "      <td>002658.XSHE</td>\n",
       "      <td>XDL</td>\n",
       "      <td>2012/3/9</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>顾家家居</th>\n",
       "      <td>113518</td>\n",
       "      <td>顾家转债</td>\n",
       "      <td>102.500</td>\n",
       "      <td>-0.92%</td>\n",
       "      <td>45.70</td>\n",
       "      <td>-1.55%</td>\n",
       "      <td>4.32</td>\n",
       "      <td>52.38</td>\n",
       "      <td>87.25</td>\n",
       "      <td>17.48%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.729</td>\n",
       "      <td>2.12%</td>\n",
       "      <td>1.62%</td>\n",
       "      <td>购买</td>\n",
       "      <td>692.84</td>\n",
       "      <td>603816.XSHG</td>\n",
       "      <td>GJJJ</td>\n",
       "      <td>2016/10/14</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>骆驼股份</th>\n",
       "      <td>113012</td>\n",
       "      <td>骆驼转债</td>\n",
       "      <td>94.740</td>\n",
       "      <td>-0.54%</td>\n",
       "      <td>9.00</td>\n",
       "      <td>-2.91%</td>\n",
       "      <td>1.34</td>\n",
       "      <td>13.440*</td>\n",
       "      <td>66.96</td>\n",
       "      <td>41.48%</td>\n",
       "      <td>...</td>\n",
       "      <td>4.258</td>\n",
       "      <td>3.49%</td>\n",
       "      <td>3.05%</td>\n",
       "      <td>购买</td>\n",
       "      <td>24.28</td>\n",
       "      <td>601311.XSHG</td>\n",
       "      <td>LTGF</td>\n",
       "      <td>2011/6/2</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高能环境</th>\n",
       "      <td>113515</td>\n",
       "      <td>高能转债</td>\n",
       "      <td>96.150</td>\n",
       "      <td>-0.88%</td>\n",
       "      <td>8.01</td>\n",
       "      <td>-0.50%</td>\n",
       "      <td>2.00</td>\n",
       "      <td>9.38</td>\n",
       "      <td>85.39</td>\n",
       "      <td>12.60%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.600</td>\n",
       "      <td>3.04%</td>\n",
       "      <td>2.58%</td>\n",
       "      <td>购买</td>\n",
       "      <td>141.81</td>\n",
       "      <td>603588.XSHG</td>\n",
       "      <td>GNHJ</td>\n",
       "      <td>2014/12/29</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鼎信通讯</th>\n",
       "      <td>113506</td>\n",
       "      <td>鼎信转债</td>\n",
       "      <td>105.980</td>\n",
       "      <td>0.26%</td>\n",
       "      <td>23.41</td>\n",
       "      <td>-1.72%</td>\n",
       "      <td>4.28</td>\n",
       "      <td>21.65</td>\n",
       "      <td>108.36</td>\n",
       "      <td>-2.20%</td>\n",
       "      <td>...</td>\n",
       "      <td>5.323</td>\n",
       "      <td>0.82%</td>\n",
       "      <td>0.45%</td>\n",
       "      <td>购买</td>\n",
       "      <td>10791.86</td>\n",
       "      <td>603421.XSHG</td>\n",
       "      <td>DXTX</td>\n",
       "      <td>2016/10/11</td>\n",
       "      <td>2200/1/1</td>\n",
       "      <td>stock</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>113 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      bond_code bond_name  bond_price bond_x1  stock_price stock_x1    pb  \\\n",
       "ST辉丰     128012      辉丰转债      79.761  -1.15%         2.06   -0.96%  0.89   \n",
       "万顺股份     123012      万顺转债      95.100  -1.59%         6.22   -2.66%  1.02   \n",
       "三一重工     110032      三一转债     121.700  -0.41%         8.46   -0.35%  2.64   \n",
       "三力士      128039      三力转债      96.066  -0.42%         5.52   -1.60%  1.90   \n",
       "上海建工     132004    15国盛EB      96.760  -0.03%         3.05   -0.65%  0.95   \n",
       "上海电气     113008      电气转债     106.500  -0.26%         4.99    0.60%  1.29   \n",
       "东方财富     123006      东财转债     119.900  -1.32%        12.50   -1.65%  4.16   \n",
       "东方雨虹     128016      雨虹转债      97.727  -0.93%        14.23   -2.80%  2.73   \n",
       "东音股份     128043      东音转债      94.339  -1.22%        10.03   -0.50%  2.29   \n",
       "中化岩土     128037      岩土转债      87.830  -0.64%         4.36   -1.58%  2.10   \n",
       "中国化学     132014   18中化EBQ      99.000  -1.00%         5.55   -0.72%  0.93   \n",
       "中国太保     132005    15国资EB     107.510  -0.45%        29.05   -1.99%  1.84   \n",
       "中科曙光     113517      曙光转债     104.600  -0.61%        38.84   -0.36%  6.94   \n",
       "中航光电     128047      光电转债     106.300  -1.16%        32.30   -5.69%  4.63   \n",
       "中航机电     128045      机电转债     107.500  -1.29%         6.53   -5.09%  2.62   \n",
       "中航电子     110042      航电转债     109.210  -2.15%        13.67   -2.15%  3.28   \n",
       "久其软件     128015      久其转债      92.051  -0.70%         7.38    0.68%  2.47   \n",
       "久立特材     128019      久立转2      94.600  -1.05%         6.18   -1.75%  1.74   \n",
       "九州通      110034      九州转债     102.300  -0.45%        14.70   -1.41%  1.54   \n",
       "亚太股份     128023      亚太转债      88.020  -0.22%         4.35   -2.25%  1.14   \n",
       "众信旅游     128022      众信转债      93.061  -0.48%         6.45   -2.27%  2.28   \n",
       "众兴菌业     128026      众兴转债      87.115  -0.71%         6.51   -1.06%  0.89   \n",
       "兄弟科技     128021      兄弟转债      96.179  -0.74%         4.38   -3.10%  1.70   \n",
       "光大银行     113011      光大转债     103.900  -0.55%         3.63   -1.89%  0.61   \n",
       "内蒙华电     110041      蒙电转债      99.200   0.20%         2.19    1.86%  1.16   \n",
       "再升科技     113510      再升转债      93.180  -0.52%         7.61    0.13%  3.21   \n",
       "凤凰传媒     132007   16凤凰EBQ      96.350   0.00%         7.68    0.79%  1.49   \n",
       "凯中精密     128042      凯中转债      95.300  -0.31%        10.25    0.20%  2.28   \n",
       "凯发电气     123014      凯发转债      92.508  -0.81%         7.21   -1.90%  1.85   \n",
       "利尔化学     128046      利尔转债     100.000  -0.20%        13.84    0.44%  2.59   \n",
       "...         ...       ...         ...     ...          ...      ...   ...   \n",
       "洲明科技     123016      洲明转债      99.120  -0.58%         8.63   -1.03%  3.13   \n",
       "济川药业     110038      济川转债     108.300  -0.10%        33.72   -0.77%  5.41   \n",
       "浙数文化     132011   17浙报EBQ      91.610  -0.21%         8.33    0.60%  1.37   \n",
       "海印股份     127003      海印转债      90.869  -0.02%         2.49   -0.80%  1.62   \n",
       "海澜之家     110045      海澜转债      97.460  -0.71%         8.53   -0.23%  3.10   \n",
       "湖北广电     127007      湖广转债      95.201  -0.31%         7.24    0.70%  0.72   \n",
       "澳洋顺昌     128010      顺昌转债      97.801  -0.20%         4.01   -2.43%  1.48   \n",
       "特一药业     128025      特一转债      93.498  -0.24%        13.03   -1.29%  2.45   \n",
       "玲珑轮胎     113019      玲珑转债     100.000  -0.15%        13.91   -1.14%  1.72   \n",
       "生益科技     110040      生益转债     102.500  -0.48%         9.50    0.00%  3.24   \n",
       "盛路通信     128041      盛路转债      99.670  -0.16%         7.06   -0.14%  1.90   \n",
       "科森科技     113521      科森转债      93.250  -0.14%         7.97    0.76%  1.89   \n",
       "航天信息     110031      航信转债     106.310  -0.18%        22.75   -0.13%  4.09   \n",
       "艾华集团     113504      艾华转债     106.600  -1.75%        20.50   -0.49%  4.03   \n",
       "蓝思科技     123003      蓝思转债      90.200  -0.24%         7.00   -0.43%  1.59   \n",
       "蓝盾股份     123015      蓝盾转债      92.280  -0.02%         5.25    0.77%  1.44   \n",
       "蓝色光标     123001      蓝标转债      95.000   0.16%         4.54    1.57%  1.57   \n",
       "赣锋锂业     128028      赣锋转债      96.100  -1.13%        23.09   -4.55%  6.17   \n",
       "道氏技术     123007      道氏转债      97.150  -1.26%        14.37   -3.23%  3.99   \n",
       "金新农      128036      金农转债      87.340  -0.98%         6.79   -2.44%  1.60   \n",
       "金禾实业     128017      金禾转债     100.801  -0.20%        15.67   -0.51%  2.33   \n",
       "铁汉生态     123004      铁汉转债      89.186  -2.09%         4.83  -10.06%  1.71   \n",
       "长久物流     113519      长久转债      98.800   0.24%        10.98   -2.23%  2.74   \n",
       "长江证券     127005      长证转债      99.000  -0.40%         5.35   -1.11%  1.09   \n",
       "隆基股份     113015      隆基转债     101.430  -0.07%        17.79    0.45%  3.19   \n",
       "雪迪龙      128033      迪龙转债      94.950  -0.47%         7.46    0.13%  2.15   \n",
       "顾家家居     113518      顾家转债     102.500  -0.92%        45.70   -1.55%  4.32   \n",
       "骆驼股份     113012      骆驼转债      94.740  -0.54%         9.00   -2.91%  1.34   \n",
       "高能环境     113515      高能转债      96.150  -0.88%         8.01   -0.50%  2.00   \n",
       "鼎信通讯     113506      鼎信转债     105.980   0.26%        23.41   -1.72%  4.28   \n",
       "\n",
       "     convert_price  convert_value  premium  ...     year  return shuishou_ret  \\\n",
       "ST辉丰          7.71          26.59  199.98%  ...    3.334   9.30%        8.84%   \n",
       "万顺股份          6.47          95.83   -0.76%  ...    5.584   2.92%        2.52%   \n",
       "三一重工          7.25         116.55    4.42%  ...    3.041  -3.31%       -3.90%   \n",
       "三力士         5.840*          94.52    1.64%  ...    5.466   2.66%        2.28%   \n",
       "上海建工          6.48          47.07  105.85%  ...    2.877   3.21%        2.79%   \n",
       "上海电气        5.190*          95.95   10.99%  ...    2.121   1.39%        0.53%   \n",
       "东方财富         11.36         110.12    8.88%  ...    5.000  -1.64%       -2.02%   \n",
       "东方雨虹         22.63          62.84   55.52%  ...    4.764   2.62%        2.20%   \n",
       "东音股份       11.430*          87.75    7.51%  ...    5.619   3.74%        3.22%   \n",
       "中化岩土          8.03          54.30   61.76%  ...    5.236   5.05%        4.56%   \n",
       "中国化学          7.66          72.45   37.46%  ...    4.342   2.27%        1.84%   \n",
       "中国太保         36.65          79.26   35.72%  ...    1.967   1.57%        0.54%   \n",
       "中科曙光         51.28          75.74   38.10%  ...    5.630   1.46%        1.02%   \n",
       "中航光电         40.26          80.10   32.70%  ...    5.879   0.59%        0.27%   \n",
       "中航机电          7.66          85.25   26.10%  ...    5.688   0.41%        0.08%   \n",
       "中航电子         14.23          95.99   13.77%  ...    5.011   0.15%       -0.23%   \n",
       "久其软件         12.86          57.31   60.62%  ...    4.466   4.64%        4.10%   \n",
       "久立特材          8.22          75.18   25.83%  ...    4.885   3.25%        2.84%   \n",
       "九州通          18.42          79.91   28.01%  ...    3.071   2.73%        2.05%   \n",
       "亚太股份         10.34          41.88  110.19%  ...    4.967   5.22%        4.71%   \n",
       "众信旅游            11          58.64   58.71%  ...    4.948   3.56%        3.15%   \n",
       "众兴菌业         11.64          55.93   55.76%  ...    4.981   5.07%        4.62%   \n",
       "兄弟科技        5.350*          81.87   17.48%  ...    4.940   2.86%        2.46%   \n",
       "光大银行          4.13          88.14   17.89%  ...    4.238   1.34%        0.90%   \n",
       "内蒙华电          2.92          74.66   32.87%  ...    5.000   2.30%        1.88%   \n",
       "再升科技         11.32          67.31   38.42%  ...    5.496   3.70%        3.23%   \n",
       "凤凰传媒         15.36          50.07   92.73%  ...    2.863   4.05%        3.50%   \n",
       "凯中精密         13.25          77.36   23.19%  ...    5.611   3.85%        3.27%   \n",
       "凯发电气          8.15          88.83    4.14%  ...    4.600   3.79%        3.38%   \n",
       "利尔化学         18.82          73.49   36.08%  ...    5.827   2.21%        1.78%   \n",
       "...            ...            ...      ...  ...      ...     ...          ...   \n",
       "洲明科技          9.45          91.43    8.41%  ...    5.885   2.74%        2.24%   \n",
       "济川药业         40.04          84.24   28.56%  ...    3.896   0.12%       -0.30%   \n",
       "浙数文化         24.39          34.11  169.57%  ...    3.658   4.03%        3.69%   \n",
       "海印股份        3.500*          71.14   27.73%  ...    3.466   7.00%        6.17%   \n",
       "海澜之家          12.4          68.79   41.68%  ...    5.564   2.55%        2.15%   \n",
       "湖北广电         10.16          71.26   33.60%  ...    5.523   3.33%        2.85%   \n",
       "澳洋顺昌          9.28          43.21  126.33%  ...    3.090   4.66%        3.88%   \n",
       "特一药业       16.100*          80.93   15.53%  ...    4.962   3.45%        3.04%   \n",
       "玲珑轮胎         18.84          73.62   35.83%  ...    4.195   3.06%        2.47%   \n",
       "生益科技         11.62          81.84   25.24%  ...    4.926   1.53%        1.13%   \n",
       "盛路通信          6.88         102.47   -2.73%  ...    5.573   2.74%        2.22%   \n",
       "科森科技          8.95          89.05    4.72%  ...    5.910   3.80%        3.29%   \n",
       "航天信息         42.38          53.66   98.13%  ...    2.477   1.41%        0.65%   \n",
       "艾华集团       21.730*          94.34   13.00%  ...    5.197   0.81%        0.41%   \n",
       "蓝思科技       16.080*          43.53  107.20%  ...    4.967   4.21%        3.79%   \n",
       "蓝盾股份        5.820*          90.03    2.49%  ...    5.649   3.78%        3.32%   \n",
       "蓝色光标       5.290**          85.63   10.94%  ...    2.995   5.51%        4.77%   \n",
       "赣锋锂业         42.58          54.20   77.29%  ...    5.000   2.74%        2.36%   \n",
       "道氏技术         24.88          57.68   68.44%  ...    5.022   3.04%        2.56%   \n",
       "金新农           9.62          70.58   23.74%  ...    5.219   4.87%        4.43%   \n",
       "金禾实业         23.32          67.20   50.01%  ...    4.866   1.90%        1.50%   \n",
       "铁汉生态          8.23          58.69   51.97%  ...    4.995   4.42%        4.01%   \n",
       "长久物流         11.99          91.58    7.89%  ...    5.885   3.52%        2.88%   \n",
       "长江证券          7.45          71.81   37.86%  ...    5.227   2.06%        1.69%   \n",
       "隆基股份         22.98          77.42   31.02%  ...    4.866   1.77%        1.36%   \n",
       "雪迪龙         9.030*          82.61   14.93%  ...    5.019   3.15%        2.73%   \n",
       "顾家家居         52.38          87.25   17.48%  ...    5.729   2.12%        1.62%   \n",
       "骆驼股份       13.440*          66.96   41.48%  ...    4.258   3.49%        3.05%   \n",
       "高能环境          9.38          85.39   12.60%  ...    5.600   3.04%        2.58%   \n",
       "鼎信通讯         21.65         108.36   -2.20%  ...    5.323   0.82%        0.45%   \n",
       "\n",
       "     amount operation         code  name  start_date  end_date   type  \n",
       "ST辉丰     购买    531.51  002496.XSHE  HFGF   2010/11/9  2200/1/1  stock  \n",
       "万顺股份     购买    683.00  300057.XSHE  WSGF   2010/2/26  2200/1/1  stock  \n",
       "三一重工     购买   2206.75  600031.XSHG  SYZG    2003/7/3  2200/1/1  stock  \n",
       "三力士      购买    297.13  002224.XSHE   SLS   2008/4/25  2200/1/1  stock  \n",
       "上海建工     购买    809.71  600170.XSHG  SHJG   1998/6/23  2200/1/1  stock  \n",
       "上海电气     购买   2422.71  601727.XSHG  SHDQ   2008/12/5  2200/1/1  stock  \n",
       "东方财富     购买   8578.44  300059.XSHE  DFCF   2010/3/19  2200/1/1  stock  \n",
       "东方雨虹     购买    408.48  002271.XSHE  DFYH   2008/9/10  2200/1/1  stock  \n",
       "东音股份     购买     64.52  002793.XSHE  DYGF   2016/4/15  2200/1/1  stock  \n",
       "中化岩土     购买    136.46  002542.XSHE  ZHYT   2011/1/28  2200/1/1  stock  \n",
       "中国化学     购买   1125.84  601117.XSHG  ZGHX    2010/1/7  2200/1/1  stock  \n",
       "中国太保     购买     35.06  601601.XSHG  ZGTB  2007/12/25  2200/1/1  stock  \n",
       "中科曙光     购买    939.31  603019.XSHG  ZKSG   2014/11/6  2200/1/1  stock  \n",
       "中航光电     购买   2644.24  002179.XSHE  ZHGD   2007/11/1  2200/1/1  stock  \n",
       "中航机电     购买    537.05  002013.XSHE  ZHJD    2004/7/5  2200/1/1  stock  \n",
       "中航电子     购买   1959.65  600372.XSHG  ZHDZ    2001/7/6  2200/1/1  stock  \n",
       "久其软件     购买    153.88  002279.XSHE  JQRJ   2009/8/11  2200/1/1  stock  \n",
       "久立特材     购买    371.93  002318.XSHE  JLTC  2009/12/11  2200/1/1  stock  \n",
       "九州通      购买    187.41  600998.XSHG   JZT   2010/11/2  2200/1/1  stock  \n",
       "亚太股份     购买    469.78  002284.XSHE  YTGF   2009/8/28  2200/1/1  stock  \n",
       "众信旅游     购买      7.44  002707.XSHE  ZXLY   2014/1/23  2200/1/1  stock  \n",
       "众兴菌业     购买    545.26  002772.XSHE  ZXJY   2015/6/26  2200/1/1  stock  \n",
       "兄弟科技     购买    326.11  002562.XSHE  XDKJ   2011/3/10  2200/1/1  stock  \n",
       "光大银行     购买  15270.09  601818.XSHG  GDYH   2010/8/18  2200/1/1  stock  \n",
       "内蒙华电     购买   1740.20  600863.XSHG  NMHD   1994/5/20  2200/1/1  stock  \n",
       "再升科技     购买     42.50  603601.XSHG  ZSKJ   2015/1/22  2200/1/1  stock  \n",
       "凤凰传媒     购买     29.96  601928.XSHG  FHCM  2011/11/30  2200/1/1  stock  \n",
       "凯中精密     购买     27.55  002823.XSHE  KZJM  2016/11/24  2200/1/1  stock  \n",
       "凯发电气     购买    296.51  300407.XSHE  KFDQ   2014/12/3  2200/1/1  stock  \n",
       "利尔化学     购买     19.72  002258.XSHE  LEHX    2008/7/8  2200/1/1  stock  \n",
       "...     ...       ...          ...   ...         ...       ...    ...  \n",
       "洲明科技     购买   1051.26  300232.XSHE  ZMKJ   2011/6/22  2200/1/1  stock  \n",
       "济川药业     购买    212.12  600566.XSHG  JCYY   2001/8/22  2200/1/1  stock  \n",
       "浙数文化     购买   1036.52  600633.XSHG  ZBCM    1993/3/4  2200/1/1  stock  \n",
       "海印股份     购买    636.75  000861.XSHE  HYGF  1998/10/28  2200/1/1  stock  \n",
       "海澜之家     购买    454.39  600398.XSHG  HLZJ  2000/12/28  2200/1/1  stock  \n",
       "湖北广电     购买    728.84  000665.XSHE  HBGD  1996/12/10  2200/1/1  stock  \n",
       "澳洋顺昌     购买    104.21  002245.XSHE  AYSC    2008/6/5  2200/1/1  stock  \n",
       "特一药业     购买     85.78  002728.XSHE  TYYY   2014/7/31  2200/1/1  stock  \n",
       "玲珑轮胎     购买    398.04  601966.XSHG  LLLT    2016/7/6  2200/1/1  stock  \n",
       "生益科技     购买    463.25  600183.XSHG  SYKJ  1998/10/28  2200/1/1  stock  \n",
       "盛路通信     购买   2756.46  002446.XSHE  SLTX   2010/7/13  2200/1/1  stock  \n",
       "科森科技     购买    661.73  603626.XSHG  KSKJ    2017/2/9  2200/1/1  stock  \n",
       "航天信息     购买    204.51  600271.XSHG  HTXX   2003/7/11  2200/1/1  stock  \n",
       "艾华集团     购买    237.21  603989.XSHG  AHJT   2015/5/15  2200/1/1  stock  \n",
       "蓝思科技     购买    351.86  300433.XSHE  LSKJ   2015/3/18  2200/1/1  stock  \n",
       "蓝盾股份     购买   1407.90  300297.XSHE  LDGF   2012/3/15  2200/1/1  stock  \n",
       "蓝色光标     购买   2105.18  300058.XSHE  LSGB   2010/2/26  2200/1/1  stock  \n",
       "赣锋锂业     购买    293.35  002460.XSHE  GFLY   2010/8/10  2200/1/1  stock  \n",
       "道氏技术     购买    779.73  300409.XSHE  DSJS   2014/12/3  2200/1/1  stock  \n",
       "金新农      购买    273.35  002548.XSHE   JXN   2011/2/18  2200/1/1  stock  \n",
       "金禾实业     购买      5.05  002597.XSHE  JHSY    2011/7/7  2200/1/1  stock  \n",
       "铁汉生态     购买  15820.43  300197.XSHE  THST   2011/3/29  2200/1/1  stock  \n",
       "长久物流     购买    318.09  603569.XSHG  ZJWL   2016/8/10  2200/1/1  stock  \n",
       "长江证券     购买    407.87  000783.XSHE  CJZQ   1997/7/31  2200/1/1  stock  \n",
       "隆基股份     购买   1092.86  601012.XSHG  LJGF   2012/4/11  2200/1/1  stock  \n",
       "雪迪龙      购买     61.01  002658.XSHE   XDL    2012/3/9  2200/1/1  stock  \n",
       "顾家家居     购买    692.84  603816.XSHG  GJJJ  2016/10/14  2200/1/1  stock  \n",
       "骆驼股份     购买     24.28  601311.XSHG  LTGF    2011/6/2  2200/1/1  stock  \n",
       "高能环境     购买    141.81  603588.XSHG  GNHJ  2014/12/29  2200/1/1  stock  \n",
       "鼎信通讯     购买  10791.86  603421.XSHG  DXTX  2016/10/11  2200/1/1  stock  \n",
       "\n",
       "[113 rows x 28 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "convert_bond_basic_info = pd.merge(bond_basic_info,stock_info_basic,left_index=True,right_index=True)\n",
    "convert_bond_basic_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts_code_list = [\"000001.SH\",\"000300.SH\",\"000905.SH\",\"399001.SZ\",\"399005.SZ\",\"399006.SZ\",\"399016.SZ\",\"399300.SZ\"]\n",
    "file_basic_path = \"C:\\\\quanttime\\\\data\\\\index\\\\tushare\\\\\"\n",
    "for index in ts_code_list:\n",
    "    df_index = pro.index_dailybasic(ts_code=index,start_date=\"20040104\",end_date=\"20141231\")\n",
    "    df_index[\"trade_date\"] = df_index[\"trade_date\"].map(lambda x:parse(x).date().strftime('%Y-%m-%d'))\n",
    "    df_index = df_index.sort_index(ascending=False)\n",
    "    df_index = df_index.set_index(\"trade_date\")\n",
    "    file_path = file_basic_path + index + '.csv'\n",
    "    df_index.to_csv(file_path)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ts_code</th>\n",
       "      <th>trade_date</th>\n",
       "      <th>total_mv</th>\n",
       "      <th>float_mv</th>\n",
       "      <th>total_share</th>\n",
       "      <th>float_share</th>\n",
       "      <th>free_share</th>\n",
       "      <th>turnover_rate</th>\n",
       "      <th>turnover_rate_f</th>\n",
       "      <th>pe</th>\n",
       "      <th>pe_ttm</th>\n",
       "      <th>pb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>20141231</td>\n",
       "      <td>2.962235e+13</td>\n",
       "      <td>2.198792e+13</td>\n",
       "      <td>3.384761e+12</td>\n",
       "      <td>2.478802e+12</td>\n",
       "      <td>7.793444e+11</td>\n",
       "      <td>1.64</td>\n",
       "      <td>5.20</td>\n",
       "      <td>15.18</td>\n",
       "      <td>14.20</td>\n",
       "      <td>1.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>20141230</td>\n",
       "      <td>2.895116e+13</td>\n",
       "      <td>2.148519e+13</td>\n",
       "      <td>3.382588e+12</td>\n",
       "      <td>2.478342e+12</td>\n",
       "      <td>7.789083e+11</td>\n",
       "      <td>1.60</td>\n",
       "      <td>5.10</td>\n",
       "      <td>14.84</td>\n",
       "      <td>13.87</td>\n",
       "      <td>1.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>20141229</td>\n",
       "      <td>2.888134e+13</td>\n",
       "      <td>2.147830e+13</td>\n",
       "      <td>3.382201e+12</td>\n",
       "      <td>2.478342e+12</td>\n",
       "      <td>7.787946e+11</td>\n",
       "      <td>2.06</td>\n",
       "      <td>6.54</td>\n",
       "      <td>14.80</td>\n",
       "      <td>13.84</td>\n",
       "      <td>1.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>20141226</td>\n",
       "      <td>2.875818e+13</td>\n",
       "      <td>2.132636e+13</td>\n",
       "      <td>3.381766e+12</td>\n",
       "      <td>2.475414e+12</td>\n",
       "      <td>7.768477e+11</td>\n",
       "      <td>1.86</td>\n",
       "      <td>5.92</td>\n",
       "      <td>14.74</td>\n",
       "      <td>13.78</td>\n",
       "      <td>1.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>20141225</td>\n",
       "      <td>2.795058e+13</td>\n",
       "      <td>2.072798e+13</td>\n",
       "      <td>3.379894e+12</td>\n",
       "      <td>2.475380e+12</td>\n",
       "      <td>7.767178e+11</td>\n",
       "      <td>1.52</td>\n",
       "      <td>4.85</td>\n",
       "      <td>14.33</td>\n",
       "      <td>13.39</td>\n",
       "      <td>1.79</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ts_code trade_date      total_mv      float_mv   total_share  \\\n",
       "0  000001.SH   20141231  2.962235e+13  2.198792e+13  3.384761e+12   \n",
       "1  000001.SH   20141230  2.895116e+13  2.148519e+13  3.382588e+12   \n",
       "2  000001.SH   20141229  2.888134e+13  2.147830e+13  3.382201e+12   \n",
       "3  000001.SH   20141226  2.875818e+13  2.132636e+13  3.381766e+12   \n",
       "4  000001.SH   20141225  2.795058e+13  2.072798e+13  3.379894e+12   \n",
       "\n",
       "    float_share    free_share  turnover_rate  turnover_rate_f     pe  pe_ttm  \\\n",
       "0  2.478802e+12  7.793444e+11           1.64             5.20  15.18   14.20   \n",
       "1  2.478342e+12  7.789083e+11           1.60             5.10  14.84   13.87   \n",
       "2  2.478342e+12  7.787946e+11           2.06             6.54  14.80   13.84   \n",
       "3  2.475414e+12  7.768477e+11           1.86             5.92  14.74   13.78   \n",
       "4  2.475380e+12  7.767178e+11           1.52             4.85  14.33   13.39   \n",
       "\n",
       "     pb  \n",
       "0  1.91  \n",
       "1  1.85  \n",
       "2  1.85  \n",
       "3  1.84  \n",
       "4  1.79  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"trade_date\"] = df[\"trade_date\"].map(lambda x:parse(x).date().strftime('%Y-%m-%d'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ts_code</th>\n",
       "      <th>trade_date</th>\n",
       "      <th>total_mv</th>\n",
       "      <th>float_mv</th>\n",
       "      <th>total_share</th>\n",
       "      <th>float_share</th>\n",
       "      <th>free_share</th>\n",
       "      <th>turnover_rate</th>\n",
       "      <th>turnover_rate_f</th>\n",
       "      <th>pe</th>\n",
       "      <th>pe_ttm</th>\n",
       "      <th>pb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>2.962235e+13</td>\n",
       "      <td>2.198792e+13</td>\n",
       "      <td>3.384761e+12</td>\n",
       "      <td>2.478802e+12</td>\n",
       "      <td>7.793444e+11</td>\n",
       "      <td>1.64</td>\n",
       "      <td>5.20</td>\n",
       "      <td>15.18</td>\n",
       "      <td>14.20</td>\n",
       "      <td>1.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>2014-12-30</td>\n",
       "      <td>2.895116e+13</td>\n",
       "      <td>2.148519e+13</td>\n",
       "      <td>3.382588e+12</td>\n",
       "      <td>2.478342e+12</td>\n",
       "      <td>7.789083e+11</td>\n",
       "      <td>1.60</td>\n",
       "      <td>5.10</td>\n",
       "      <td>14.84</td>\n",
       "      <td>13.87</td>\n",
       "      <td>1.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>2014-12-29</td>\n",
       "      <td>2.888134e+13</td>\n",
       "      <td>2.147830e+13</td>\n",
       "      <td>3.382201e+12</td>\n",
       "      <td>2.478342e+12</td>\n",
       "      <td>7.787946e+11</td>\n",
       "      <td>2.06</td>\n",
       "      <td>6.54</td>\n",
       "      <td>14.80</td>\n",
       "      <td>13.84</td>\n",
       "      <td>1.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>2014-12-26</td>\n",
       "      <td>2.875818e+13</td>\n",
       "      <td>2.132636e+13</td>\n",
       "      <td>3.381766e+12</td>\n",
       "      <td>2.475414e+12</td>\n",
       "      <td>7.768477e+11</td>\n",
       "      <td>1.86</td>\n",
       "      <td>5.92</td>\n",
       "      <td>14.74</td>\n",
       "      <td>13.78</td>\n",
       "      <td>1.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000001.SH</td>\n",
       "      <td>2014-12-25</td>\n",
       "      <td>2.795058e+13</td>\n",
       "      <td>2.072798e+13</td>\n",
       "      <td>3.379894e+12</td>\n",
       "      <td>2.475380e+12</td>\n",
       "      <td>7.767178e+11</td>\n",
       "      <td>1.52</td>\n",
       "      <td>4.85</td>\n",
       "      <td>14.33</td>\n",
       "      <td>13.39</td>\n",
       "      <td>1.79</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ts_code  trade_date      total_mv      float_mv   total_share  \\\n",
       "0  000001.SH  2014-12-31  2.962235e+13  2.198792e+13  3.384761e+12   \n",
       "1  000001.SH  2014-12-30  2.895116e+13  2.148519e+13  3.382588e+12   \n",
       "2  000001.SH  2014-12-29  2.888134e+13  2.147830e+13  3.382201e+12   \n",
       "3  000001.SH  2014-12-26  2.875818e+13  2.132636e+13  3.381766e+12   \n",
       "4  000001.SH  2014-12-25  2.795058e+13  2.072798e+13  3.379894e+12   \n",
       "\n",
       "    float_share    free_share  turnover_rate  turnover_rate_f     pe  pe_ttm  \\\n",
       "0  2.478802e+12  7.793444e+11           1.64             5.20  15.18   14.20   \n",
       "1  2.478342e+12  7.789083e+11           1.60             5.10  14.84   13.87   \n",
       "2  2.478342e+12  7.787946e+11           2.06             6.54  14.80   13.84   \n",
       "3  2.475414e+12  7.768477e+11           1.86             5.92  14.74   13.78   \n",
       "4  2.475380e+12  7.767178e+11           1.52             4.85  14.33   13.39   \n",
       "\n",
       "     pb  \n",
       "0  1.91  \n",
       "1  1.85  \n",
       "2  1.85  \n",
       "3  1.84  \n",
       "4  1.79  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df = df.sort_index(ascending=False)\n",
    "#df = df.set_index(\"trade_date\")\n",
    "df.to_csv(\"C:\\\\quanttime\\\\data\\\\index\\\\tushare\\\\000001.SH.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'20150103'"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmpdate = \"2015-01-03\".split('-')\n",
    "tmpdate = tmpdate[0]+tmpdate[1]+tmpdate[2]\n",
    "tmpdate"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
